Collecting physical media is very valuable if you are a passionate gamer. Time has proven that the older a game gets, the harder it will be to legally obtain it. Yes, emulation is a thing but doesn't quite beat the experience on the original hardware IMO. And of course emulation is under constant legal scrutiny to the point where it's only a matter of time before enough money passes hands and emulation itself could be outlawed or heavily restricted.
Unless you have extraordinarily rare games, likely you will not see any financial benefit. If you do not want to play any of your games ever again, and you will never have kids or anyone you want to pass history onto, then likely the collection holds no value.
All of these options are unreasonable when you are talking a whole household and catering to a family that is not tech savvy. I have a pihole and it does not block ads from the YouTube TV app.
I have a plex going with content enough for the adults, but the kids consume so much media there is no reasonable way to get enough and fast enough and to meet their current interests. Youtube is the only streaming subscription we have left in the house because nothing even comes close for kids. Even Disney+ completely fumbles when it comes to appealing to what used to be its target market.