It's gonna vary from person to person, depending on their space needs, if they have a tendency to give away old media they no longer use, etc.
I personally am not a fan- I put a lot of value into the tangible object of the game. Plus, most games are stored specifically on your personal machine, & can't be easily transferred around- if I want to bring a game to a friend's house, I throw the disc in my bag. If I want to take a digital game, I have to get my profile on their machine, verify it, mark the machine as one of my authorized devices, and re-download the game. Granted, the modern gaming scene & its massive download patches make using physical discs inconvenient too- but it's still easier. Plus, you generally can't trade, sell, or give away a digital copy. For example: I bought the complete edition of Horizon Zero Dawn & the Royal Edition of Final Fantasy 15. My old basic copies were given away to friends who hadn't yet tried them yet. On the other hand- my physical Recore: Definitive edition caused my digital vanilla Recore to vanish into the ether, with no option to pass the license onto a buddy. Feels like a waste, really.
Music media isn't nearly has bad, as you can typically host the files on your own storage & move/use the files are you will regardless of 'authorized devices' or online status. Plus, since songs are usually short, being able to carry around dozens of them on your phone or a 2-inch pocket box is very handy. (I still buy CDs to rip most of the time though, I only go pure digital for single songs or albums not available on disc.) I feel like if I could use games in a way similar to MP3s I'd be more into digital.