For most personal projects, hosting on the cloud may be overkill, but tempting with its supposed ease of use and benefits of scale. Self-hosting is often overlooked as a solution with the benefit of simplicity and cost.
Interesting discussion and demonstration of self hosting the kinds of apps most personal projects will end being.
I havent bothered yet but it has been a thing I thought about. I have vaultwarden and my logins are two clicks which is nothing compared to the work I had to put in. :D
But yes, I think proxy level auth should work but dont take my word for it.