This really was a huge, huuuge missed opportunity. The physical console is amazing and the inside should be enough to run the games too. I'm just going to wait and not play anymore until they make it easy for randoms to mod it with custom emulator and ability to delete and add game roms. Should be soon considering it came fairly quick to nes classic and that seems to have been much harder to hack.
At the time of writing, the PlayStation Classic deal is available right here at Walmart with free 2-day shipping. Despite the console's shortcomings, it is definitely worth considering at this price. A quick search on the Internet will illustrate that the console is super easy to hack for adding new games, so you might be able to get a lot of bang for your buck. It's even cheaper than going the Raspberry Pi route at this point, and you'll get a cool PlayStation case to boot. Just keep in mind that there's no telling how long the deal will last this time around - it could end at any moment
Don't risk it. Look what happened to the PS TV. Many waited for the $20 price point instead of picking it up for $40. Now the PS TV is out of stock and no longer in production. If you want one today it would cost you $200 for a new PS TV.
2 weeks ago the Walmart I shop at had several shelves of them. They only had 2 consoles left this week, so I got one just in case they become scarce. I'll probably spend more time figuring out what I can do with it than actually playing it.