I guess there is room for debate with the NES Classic and the PlayStation Classic (since even their original controllers were kinda meh), but for the SNES Classic, the thing was barely above the price of two good controllers, hardly making it overpriced. Also, mileage may vary, but I played through the whole of Earthbound and Super Mario RPG on it, plus whole playthroughs of Contra, Castlevania, Super Ghouls n' Ghosts, F-Zero and a good chunk of Super Metroid (most of those with a friend who grew up on computer games). Depending on the game list and the quality of the emulation, I'll certainly buy this thing to play with him some of the titles or catch up on classics I missed.
The notion that "games back then were only good/tolerated due to having nothing better to play barring a handful of exceptions" is also pretty absurd. There are hundreds of games that aged perfectly well. As I mentioned, as far as visuals go, many polygonal PS1 games will look a bit gaudy or shoddy today (I can't think Tekken aged very well), but I am pretty sure those that had strong aesthetic choices will still work reasonably well (Metal Gear Solid, Silent Hill, Vagrant Story or, in a totally different style, Tobal N°1, come to mind). Obviously, visuals are just one part of the equation and, on top of that, many classic games on PS1 are mostly sprite based (Symphony of the Night and Final Fantasy Tactics are the obvious examples).
On a side note, something that will have aged super poorly for sure will be most CGI intro movies! It's pretty crazy to consider what is being done in real time these days compared to what used render farms back then!