I don’t know if this would meet your needs, but I recently built a gated static site for personal use using Gatsby + Firebase for Auth and Hosting. Firebase Auth took 10 minutes to set up. I didn’t need a DB but I will use Firestore if needed in the future. All of it was quite easy and enjoyable to do.