Check out strawberry, a fork of clementine. It can track plays favs and stars locally. As well as synch to and from services like musicbrains and last.fm. it's also great for collection management.

For slick looking displays etc check out tauon. The playlist maker and cover art grid are fun to play with.

I keep coming back to Tauonbox. Great player.

I stille wish they released an native version of Musicbee for linux. Great player as well!

I use mpd to play music. While this is particularly interesting for things like a home audio setup with a server and multiple devices that can control it, you can also just run it locally on various machines, like I do. Gives a lot of flexibility in terms of UI and so forth, since the frontend is decoupled from the backend.

It looks like there's a software package

which I have not used

called mpdtrackr which maintains audio statistics for an mpd instance. Its project page explicitly talks about some sort of mechanism for syncing statistics using Syncthing.

I vibe with your quest, but why not use an external scrobbling service?

If you're looking for something like unwrapped, I don't think it exists.

For the stats and a nice experience, you've got Roon obviously, but that's kinda pricey

Plex tracks some data and still doesn't need the syncing since it's a server based model

I've never used it but there's a foobar2000 alternative for Linux called Deadbeef, that'll probably do it