Music app lost iTunes playlist formatting in Time Machine transfer to new MacBook

Once again, the ‘reliability’ of Time Machine is questionable. And/or is it the (crap) ‘design’ of the Music app that has screwed all my playlists in their transfer from the iTunes app to the Music app on my new MacBook?

Why did my highly detailed, multi categorised, very sortable, iTunes playlist formats not transfer across to the Music app? 

Do I seriously have to individually, manually, reformat each of my hundreds of playlists to view all the 24 categories of metadata (inc BPM composer, genre, size, release date, kind, etc) that I previously viewed in iTunes?! 

Even worse (and it seems unfixable in the Music app) I can’t even search for the music of one artist and see their songs in list view or sort via any category of the metadata that was previously enabled in iTunes. It only displays the name of the song in box format. No list format or sortable metadata. Completely unworkable. Useless.

Its dumbed down new default format is to only display 6 categories of the song’s metadata (song, rating, artist, album, time and ‘love’ 🤮) in the box view which I can’t sort by name, date, size or whatever I want. The search results don’t even include words in the comments.

Why can’t I activate a default, more complex, 24 category view for any new playlist in Music instead of having to manually (metadata item by metadata item) set that up each time I add a new playlist? It’s as simple as enabling us to set a default new spreadsheet format setting - like you can in Excel. You’d think that’s not too hard for Apple, but apparently it is.

The Apple ‘Senior Advisor’ I just spoke to on the phone said that Apple don’t have any Music app specialists on staff so I can’t talk to one! Wow! Another way of ******* off people who want to work with music on this declining platform. The Senior Advisor needs to ‘research it for a day’ before he gets back to me!

Computers are meant to save us time and be increasingly user friendly. Instead Apple is speeding in the reverse direction. The Music app has been around for almost 7 years and they haven’t bothered to make it more user friendly. I delayed purchase of a new computer because they always stuff us around in this kind of way. 

The disrespect Apple shows to music enthusiasts and music professionals is extreme. The Music App should be a step up from iTunes but in reality its functionality just fell off a cliff.

I don’t want a streaming service or Spotify. I support musicians getting paid for their music (without artists having to rely on touring or merch production and sales) and streaming services do that extremely poorly. Yes, Apple still has a music sales platform, but they don’t provide the basic simple infrastructure to manage the purchases in more than toddler level complexity. It’s pathetic.

If you have any suggestions for fixing my situation, I’d appreciate your help - including non Apple fixes. Can new PCs still run iTunes in the way I have described?