Alternatives to the Music App on my new Mac, to play my own music collection

So let me be a bit more precise:

I want to be able to access my music catalog through a Finder type method. My Music folder is organized by artist with all albums of an artist in that folder, listed by year. In some cases, if an artist also has a multi-album compilation, those albums are in the compilation folder. Some albums are organized under their own Genre folder, and all multi-artist albums are in folders named Various Artists.

With Apple Music, I seem to be stuck with only being able to sort my music by Album, Artist, Genre, and Song. However, when a choose an artist, I cannot access that artist's body of work in columns, but I'm restricted to the Album formatting, and, if I have many albums by one artist (e.g. about 30 albums by The Rolling Stones, The Beatles, etc.), I have to scroll through everything in order to get to the one I want. It's a bloody PAIN in the A**!

And, if I want to find an artist on an album of various artists, and then play that album, it's a nightmare!

Maybe I'm not seeing some obvious solution to this, but, honestly, I find Apple's methods extremely arcane and not at all the easy, user-friendly system that is touted by many. I'm really starting to regret moving from the PC system!

BTW, I have a 2019 Mac with Intel 8-core i9, running the latest version of Ventura, I have no idea what Catalina is or how to run a "Windows" version of iTunes (an Apple program!) on a Mac (the whole idea sounds quite ridiculous!).