Spotify and PocketCasts almost exclusively here for me, and they work great when they don't glitch out for whatever reason ("Something went wrong" or "Content not available"). My wife occasionally uses Audible. I was floored to find that Libby has an app too (for audiobooks through the public library). Anything else... well, I came from a car that pre-dated CarPlay, so I'm not as allergic to the old phone mount + Bluetooth setup as some people are. iHeartRadio lists the handful of non-local stations I might want, but they never seem to work.
I rarely use DC charging, and when I do, that time is spent convincing my kids that yes actually you should pee now even if you don't "neeeeed" to. I could see it being more annoying if you travel alone often. Sounds like video streaming is rolling out slowly though.
"The rest are disappointing" - if you dig deep enough I think you'll find that 90+% of the apps on both iOS and Android are trash too. I get it though - it's just there's such a small number of apps available on AAOS that the dregs are a lot closer to the top of the list.