I really like Astro and Quik.

If you want to take a step further start from a template like astrowind.

It's opinionated performant and works really well with react, Svelte, or any other fe framework. You can even mix and match them.

But for what you are looking for you are better served by combining it with firebase or a firebase clone.