back when I used xubuntu I used gmusicbrowser.
Now, debian 12.5 netinst came with quod libet installed and it can handle 60k files so far.
note that my music collection is stored in 4 different SSD.
If there is anything better than quod libet, what would it be?
Strawberry or Clementine. I mean 100K entries in a database is nothing. Even for SQLite. You can add multiple library locations, this is no problem.
You probably want Strawberry as it is newer and maintained, but I still like Clementine for the extra features that Strawberry doesn't have yet. For you probably, not a big deal - things like podcast support, cloud support etc.
I'd imagine mpd with one of many frontends would work well enough. You'd just need to use a dummy music library directory with symlinks to your four music storages for mpd to pick up and catalog everything.
I'm not sure what a "music jukebox" is, and how it's different from a music player, but I would recommend to try mpd. It should work with your collection, although I don't have personal experience with collections of this size. Some clients might also not have been designed to work with such collections, so probably you'd have to try several.
