You can check out music streaming servers such as Navidrome (Jellyfin also works) for that together with a compatible client such as symphonium This is a closed source app but the most feature complete. I use Tempo but has no android auto support I believe.
I prefer native music apps because, in my experience, they offer a smoother experience compared to PWA. I don’t mind using PWA, but the Music Assistant PWA sometimes annoys me with its delay in loading items.