Where is music stored in macOS Sonoma?

From iTunes to the Music app there have been a lot of changes over the years. I'm trying to find out where music that's in the Apple Music app is stored.

My Home/Music folder looks like this

The folder called Media contains another folder called Music. In there is my actually music tracks in folders with the artist's name.

Is this where everyone's music is stored? Do all systems look like this? Or do new systems organize content differently?

Thanks very much.

[Re-Titled by Moderator]