The website version of YouTube Music that I use on the PC is all right, but the app version I use on my phone is a usability mess. Google Music was so much better, but Google has become Microsoft. They're too big to care about making their products good any more.
For offline playing on my computer, I use Winamp. Full stop.
https://skins.webamp.org/ shows what the UI/UX was for it. Which is basically an old version of the current website. Flashy and modern.
Random anecdote: I had a SNES emulator at the time that was fast enough to play "Zelda: Link to the Past" but only as long as I did it without sound. Winamp was fast enough that I could keep it playing in the background without slowing down the game.
If you had a 486-100 with 4 MB and playing MP3s and not noticing, that would be lean.
There were other players out there. I remember using K-Jofol, but I don't remember if it had a reputation for being leaner or just having wild skins. I know mpg321 exists which is integer only decoding for speed (it made a difference on my super low end box), but I don't know if it was available at the right time.
MP3 playback would pop and skip if anything else tried to touch the CPU, under Linux or Windows, even on Pentium machines (there weren't 30 background processes of dubious value constantly begging for time like on a "modern" OS, so this rarely happened unless you tried to do other stuff while the music was playing). Choice of player didn't make much difference. Contrary to common wisdom, Linux was, if anything, even worse about this than Windows, but neither was good. QNX or BeOS, however, could handle MP3 playback while multitasking and web browsing without any glitches, even on a 486—though I don't know if I ever tried with RAM as low as 4MB, most likely 16MB was about as low as I went, since I had several of these systems and was able to assemble a couple really good ones by borrowing parts from others.