There are drawbacks to any collection method, physical or digital, and at some point those drawbacks start to wear on me and I start to loathe the collection process. After enough loathing, I get rid of it. Or if transferring it between computers or apartments is more work than I'm willing to put in, I get rid of it.
Sure I've had to buy the same album two or three times on occasion, but not nearly as often as you might suspect (especially now that streaming services are a part of my listening habits). I'm much happier now that I'm not meticulously collecting and worrying about backups and such. I have an ever growing MP3 collection which is mostly stuff from bandcamp (and other artist-friendly digital sellers) and some ripped CDs. But I don't back it up, and I won't transfer it to my next computer (though most of the digital purchases are re-downloadable, at least for now). I stopped completely with physical media after living in a few very small apartments, and since I no longer have a turntable or CD player (or a CD drive, for that matter). So I just do streaming services or local MP3s (not meticulously organized -- I can just search the HD). It's not perfect, but neither were all the other methods I've tried (which include many of the systems people have suggested in the comments here), and this is far less work for effectively the same result.
If anyone's feeling collector-burnout, I highly recommend just getting rid of your collection (throw or give away, don't try to sell the sell-able stuff) and starting again simply.