Like the other guy said, used/refurbished pixels are pretty good deals. The overheating is a bit overblown, yes some people get a bad device but you can just return it if it's really bad. My experience with the pixel 7/ 7 pro is that it's very smooth and don't notice any overheating even in hot climate, and Android 14 and also the upcoming 15 updates helps with heat and battery significantly.
Yeah this works perfect for me too. Using full installation it even download the latest working Spotify and removes the ms store version automatically. But I can also confirm mrpond blockthespot is also safe, just different developers and less features.
Not just Tidal, even qobuz, deezer (I find most on this one), Amazon music have a flac option or you can use apple music and download alac. All way better quality than YouTube or Spotify.
It's on izzyondroid repo: https://apt.izzysoft.de/fdroid/index/apk/com.deniscerri.ytdl
Also I highly reccomend it, it even integrates sponsorblock so you can download only the parts without ads or intros.