I agree with what you are saying, and I think this is perhaps the most important tradeoff that many CMS designs do not deal with properly. This is particularly

I agree with what you are saying, and I think this is perhaps the most important tradeoff that many CMS designs do not deal with properly. This is particularly true of the current plethora of 'static site generators', many of which are not really improvements in any aspect. If you build a static site, you can concentrate on making sure a rebuild is quick; if you build a dynamic site, you can concentrate on making sure the data structure is robust to scaling. You might never be without these problems, but you can minimise them to the extent that they are no longer costing your users excessively. It's not that we need to go back and forth: either solution could work perfectly fine for all but the heaviest sites.