I agree with most of this, which is why emulation is generally better unless you specifically want to operate/show off a museum.
Maybe things will be like the Nintendo BS-X where people will reverse engineer consoles with games downloaded to extract the game from it.
That being said I do have a physical Atari 2600 with a few games. Astroblast with paddles is still a fun game today, and Video Olympics (the Atari VCS version of Pong) is extremely fun to bring out at parties.
the Atari 2600 is probably my favorite console to collect for. The games cost next to nothing and old games like that are fun to just grab a stack of and play each game for 5-10 minutes each