MPD works pretty well for the music thing, and, I don’t know if this is would be an option for you, but I programmed my own smart-paylist-generator in rust as a hobby project to get control of my 500Gb (around 10,000 100% legally acquired tracks cough, cough) library. The additional control over the algo meant I got something that works waaaay better than pretty much anything else I’ve tried (including Spotify suggestions, etc. — the only thing I still use is Bandcamp for new artist suggestions); if you have the time, I highly recommend a homemade solution like that. It is a lot of work though.