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.
Glad to see Music Assistant is getting updates. It is the only way to keep my Sonos speakers working as the Sonos app hardly ever works for me.
Can’t wait for the latest camera which I can’t afford. ¯\_(ツ)_/¯