You seem to be mistakenly thinking that more tables by definition always == more queries. That isn't the case. A bunch of those tables rarely get queried.

I really don't understand people's aversion to database tables. I have a join, the world is ending! Pay attention to your indexes and 9 times out of 10 everything will be fine. For that 1 other time, there's Varnish.