In reality, the Pi solution is 99% set it and forget it. I haven't touched my RooExtend Pi endpoint in months. Same with the SoTM. But these are strictly endpoints, not servers. But I understand your point.
The Pi is the endpoint, if you don't want to mess with a server, I can understand that too. For streaming, Qobuz uses chromecast or Airplay. You'd just use that option from the app on your phone, tablet, etc.. I know Tidal has Tidal connect, but I'm unfamiliar with Tidal. Amazon music IIRC is Chromecast or Airplay. Apple Music is the same.
Roon would work, but not well for this application. You'd have to rip the albums and tag them for Roon to work well. That would be an extreme labor of love.
Yes, that's all you need. Preferably choose a streamer that can be used directly from the Qobuz or Tidal app.
I can't give enough praise to the SoTM Neo200. The darn thing just works. I use mine with a $25 WiFi adapter, but have used the Ethernet as well.