@ALostInquirer For books I use Calibre on my computer and I've recently started to use Bookwyrm in exchange to Goodreads (although pretty much all my friends use the latter).

For Music I use Discogs (for physical media) and maybe Bandcamp (for digitally owned media? idk, I just download them and use whatever music player I have on each device)

For movies I started using Letterboxd, recently migrated from IMDb, but it seems that not all movies are there yet, idk.

For photos, on my phone I use Google Photos without a Google account (I'm no longer syncing to them since they removed the unlimited backup feature). But Aves is also a great option which allows you to edit tags.

Never bothered about games tbh.