Hi Russell,
All of that is possible with my Kenwood head unit. For me, mostly CDs, as I currently don't own a smartphone. I'm resisting the temptation so far (as I hate the bloody things), but no doubt will succumb at some point!
What I can do, however, when the car's parked outside the house, is access our wi-fi and use the Internet, as the head unit has that facility, and so in that respect simply acts as a computer, and therefore once online, I can log onto my Tidal account and access my playlist (or play any other music), or go onto YouTube - same applies with movies!
Marco.