Seems relevant here - why is nextjs so popular? It’s always seemed a bit mad that people took a very nice static site system and decided to add a server to it.
I agree, NextJS used to be my go to for building any kind of web applications, it was essentially a full stack framework capable of handling complex requirements, however since they decided to go all in on this new React Server Component bs, I'm so done. Sure there are some benefits here and there but overall, its a huge loss of DX and UX. React was always supposed to be a front end library, not a full stack framework and now the direction of React is being lead by the NextJS team so there is no hope.