so I tried migration, but quickly learned that Astro is not great for my use case

I also tried Remix and that went a bit better. However, until they add support RSC, Next.js DX remains superior