Like you I've not treated it well – I've migrated the library across at least four computers, backed it up, restored it, and it's even been used by two computers simultaneously on a shared drive – and it's always worked fine.
The UX is also fine, even with Apple Music turned on. It does a lot of things, but it's still the best music player out there.
Every time I've tried to use something else, a missing or not well implemented bit of functionality has always brought me back to it.
Apple probably should have split the iPod/iOS/app management functionality into a separate utility, but iOS devices are now completely stand-alone, so they could drop all that stuff without issue.
And Apple Music is fantastic - it nailed my musical tastes way more accurately than Spotify, and I've used Spotify for years. The playlists it suggested were almost spookily good.
I tried Google Music on my phone for a while, and really didn't get on with it. Like all the Play services, it felt clunky and didn't have the polish it should. Using it felt like work.
You have to try playing those again if you want the songs to come up in shuffle, since it's the only way to clear the "missing" status.
This despite abusing the hell out of it:
* My library is on an NFS volume,
* ..accessed with two different copies of iTunes on two different OSes
* ..with north of 20k songs
* ..and a library that's been backed up, restored, migrated, multiple times
*..all the way since ~2002 when I got the HP branded iPod and started using it to manage my music
The only conclusion I can come to, computers being deterministic machines, is that a lot of people have broken computers. Perhaps iTunes needs to be more error tolerant?
There's not a whole lot of ways to say "it works for me, and I don't know what you're on about" without being straight up dismissive but.. it Just Works, at least for me. Just another data point I suppose.