I think the killer feature of Django is the Admin framework, its so often overlooked when developing a site/app that internal (not user facing) tools are so important. With the Dango Admin you get something incredible with so few lines of code. It's practically a super power.
If you need a little more interactive "SPA" like functionality, throw in Django REST Framework and your preference of front end framework. I would tend to go with Vue as it feels like it's the same sort of "battery's included" framework as Django. You can also easily use it to build smaller components without having to go all in on SPA.
If you are then asked for a Mobile App on top of that I would reach for Ionic/Capacitor, particularly if you already have a (partly) Vue or React based front end. You can then reuse most of your code. Need some native functionality not covered by Capacitor plugins? take a look at brining in NativeScript, it works brilliantly with Capacitor. (If you haven't taken a look at modern Ionic/Capacitor it has come on so far since the Cordova/PhoneGap days)
Heck, I'm even releasing my SvelteKit stack as a SaaS boilerplate for others to launch projects more quickly: https://sveltesaas.com
“The fundamental difference here is that Next.js has four "modes" for getting data on the page: (1)getInitialProps - called server and client side (2)getServerSideProps - called server (3) getStaticProps - called at build time (4)client fetching - called in the browser with Remix there is only 1 called loader”
I've been building projects in React since around 2016, and Next.js just makes the annoying things go away (static rendering for SEO pages, image optimisation, code/bundle splitting, page routing, etc).
C# and Kotlin offer a nice balance between rigor and accessibility and have good docs and tooling. Using the same language across the stack makes collaboration and debugging simpler. Large labor pool of devs who prob have a bit stronger CS fundamentals than the average JS/TS dev, but still prob have a web/mobile app focus/experience
Here's how the landing page describes it " Built on React, GraphQL, and Prisma, with full TypeScript support, and Webpack/Babel ready to go with zero config. Redwood gives you the workflow you love, but with simple conventions and helpers to make your experience even better. "
For prototyping I liked postgrest or api-platform.
https://typeorm.io/ is also nice...
I think tooling to generate typesafe SQL methods from inspecting a DB is a big win for the Deno ecosystem. And an equivalent for Storybook. From that point forwards, it’s pretty good for lean projects.
It's simple, cheap to host, reliable, and you can go a long distance using plug-n-play components (plugins, themes, etc.). The only limitation is it doesn't make sense for certain types of software (e.g. it's not super useful for building an online bank or something).
I really like Vite and the Vue3 setup script syntax, I might switch entirely to VueJS in the future, but the React libraries are better.
Graduate to React if and only if required.