For aesthetics? No question Apple's superior.
For navigation? A tossup in my experience?
For discovery of places and reviews? Google's so far ahead it's not even close.
Apple's interface with Google's database of places and reviews would be the holy grail.
It's wild to me that Apple hasn't spun off their own reviews system yet. Relying on Yelp in 2023 seems foolish.
The real problem of Apple Maps is that outside of the US it's quite poor, so one is forced to use google maps quite frequently.
Anyway my point stands: if something doesn't have a clear business model, I'm not happy using it. If the business model is ads I'm very unhappy using it.
For navigation, if you’re in a region where Apple has their “new maps” which have maximum speed, traffic lights, 3D buildings etc. then navigation is on par with Google with some nice extras thrown in because Apple owns the platform (like: navigation on the Lock Screen, custom notification styles etc.) Except bike navigation which Apple still does not offer in the bike capital of the world, The Netherlands.
As for location data…yeah Apple is indeed bad. Both in number of places it knows, in accuracy of their data like opening hours and especially in reviews which is regurgitated from terrible sites like Yelp or TripAdvisor.