Navidrome is great for streaming self-hosted FLACs, but checking what my kids are listening to meant constantly logging in and out of different accounts and since playback history lives entirely in client apps, past history vanishes into the void.
Instead of fighting third-party scrobblers or writing complicated webhooks, I just pointed a tiny Python script straight at the local SQLite DB. Now, a regular cron job drops a clean, zero-tracker static HTML dashboard into an Nginx container. No cloud services, no telemetry, just a local page to see family play counts.
Navidrome Dashboard can be found on my tools page here: 🔗 https://unknownuniverse.uk/tools
I think it is best to talk about music instead of looking at their habits. That way they can freely express their music taste without feeling like being spied on. That way they can share what they feel like sharing.