my current go-to stack for webdev is svelte on the frontend with a golang api on postgres database. Deploy behind an openresty ( nginx's fork ) server.
Usually quite performant, easy on cloud resources and even fun to work with... ( also "modern" enough so i would not have to explain to others what a perl-cgi script is )