I use Arc, a paid app to track my location that stores this data on my device and only on my device. It has a good but not great UI to explore this on device, make corrections on transport types which are by default inferred by machine learning, mark and manage points of interest. The UI is somewhat complex so it's not the easiest to use, but it's easy enough after a while.
Since you explicitly mentioned moving away from Google, I'll note that the app has an opt-in integration with Google Places. You have to click a "Search Google Places" button to activate it so you won't accidentally use it.
It's self-hosted in the sense that it's just an app.
https://apps.apple.com/us/app/arc-app-location-activity/id10...