Then we can go the other direction. Popping a partially full card in my camera with media that I can’t sort through at a glance/quickly. Library software isn’t going to help you there.

Best practice is to dump, back up, and format. If you’re doing photos and you’re not shooting several gigs per shot hundreds of times then sure you can hold onto those SD cards, but then you need to take them out of rotation.

Ultimately boils down to the kind of user we are talking about, which is incredibly varied