I'm surprised about:
>4. Database queries can probably be left uncached
...but maybe I am thinking about it wrong. Imagine building Quora as a Rails App. For all the interesting user stats like "your answers have been viewed 28,000 times" I feel like your choice is to either denormalize in the application logic and database or cache the complex queries. Are most people taking the first approach?