Static generation is the fastest way to serve a page, until the content changes and the site is stale until the next deploy. The answer isn't abandoning static; it's picking the right strategy per page.
Marketing pages, docs, and articles: fully static, rebuilt on deploy. Content that changes occasionally: incremental static regeneration, so the page stays fast and refreshes in the background. Truly dynamic data: server-rendered, no cache.
The mistake is applying one strategy everywhere. A records list shouldn't be static; a blog post shouldn't hit the database on every view. Match the rendering to the change frequency and the site stays fast without going stale.