Yeah no kidding. SOCOM was a big online game for me, I played FFXI for abit, I think I played Battlefront 2 on PC, but I did play Battlefield Modern Combat on the PS2. Hell, the Final Fantasy XI PS2 servers lasted till 2016. The console was discontinued in 2013. There were the Resident Evil Outbreak games. I know there were a few other good ones too. I'm pretty sure I remember the Dreamcast had a number of other issues to overcome, but I haven't really delved into the Dreamcast enough to know for sure with that.
The Wii worked because it had a crap ton of games, no matter the quality, so it appealed to a casual market, the market that actually sells systems. It was unique and had a ton of games. The Wii U was unique to people that truly understood it, but Nintendo failed to justify its unique feature. People thought it was a Wii attachment, as the terrible Wii U name didn't help. The marketing for the system wasn't great (People have said they think the Switch has done more to market itself just in the lead up to the launch than the Wii U got in its entire lifespan). There aren't many unique games for the system either. Of the very small library of truly good games for it, I'd probably not be able to pull out ten that I would say are "innovative or unique". The console simply did not have enough games to draw more people in. Simple as that. Even when it did get multi-platform games, the Wii U was rarely the better version and often was not as good as the other versions.