KBExit hard to say. I think my production 1.8 forum (it's a small piano forum with 10-15 posts a day) hosted on Siteground (a shared hosting) feels a little bit snappier than DIscuss (this forum) but I might be making it up.
To complicate things further, I am testing the 2.0 beta 8 on a Hetzner VPS because I will certainly abandon Siteground and move to a VPS. But I guess the best comparison would be to copy the 1.8 forum to Hetzner, so I compare the performance between 1.8 and 2.0 in the same environment.
I mean, I fully agree it could be something in the environment and I might be missing something simple. I am just checking with other people and with the core devs, maybe they can recognize the above SQL profiling because to me it still seems valid, the SQL queries are indeed a bit too heavy.