As for self hosting overpass, I have considered it, but the installation steps seemed a bit tedious to me compared to a lot of tools which are dockerized.
Protomaps also provides a free set of base tiles that you can download and rehost yourself if you don't want to process the data locally.