I hate to come in sounding like an Eve Online fanboy, but your post does sound a lot like someone who got the trial, went 'meh' and thinks they've seen all there is to see. Feel free to TL;DR to the end of this to check out some game recommendations instead.
You are absolutely wrong about 0.0 first off. First off, there is no "endgame" in Eve. This isn't WoW or WAR. Secondly 0.0 is open to new pilots even with low skills. A newbie in a properly fitted (and by that I mean the right setup not necessarily T2 gear) frigate can work as a low cost interceptor quite easily, for example. That barely takes any time at all to train for. Believe it or not, creative T1 fits can be quite effective and not break the bank.
Combat is far from that simplistic, with some ship builds requiring a good deal of hands on management in order to keep yourself from capping out and proper module activation timing. On the broader spectrum, fleet commanding is pretty intense stuff and great fun to learn to do.
Go get into an interceptor duel with someone who knows what they're doing and try saying combat is boring again.
:D
Getting podkilled is a bitch, true, but jump clones exist for a reason. Clone insurance is also very cheap so really if you get popped without it that's your own damn fault.
NPC Missions are kinda wank depth wise, but CCP is constantly adding new ones with better laid out mission briefings and do eventually plan on actually adding NPC AI beyond just the recently added sleepers (which for anyone who's been out there knows that they're no slouches and will rape the first logistics ship to show up and say hi).
You are right on one thing though, Eve is not a tourist's game. It takes a fair amount of time at the beginning to get through the initial learning curve and general entry barrier, and this puts off a lot of people who don't have friends in game to help them out. It's entirely up to the player motivating him or herself to get out there and make something of the game. It doesn't hold your hand and gently point you at a few wolf cubs to go kill for cheap xp, which really, is what most gamers want in a game. It instead says "here's your rookie ship, have fun!" and leaves it up to you. Definitely a niche game, but a successful one.
You may want to check out Jumpgate: Evolution which features hands on ship control with classic space sim combat.
http://www.jumpgateevolution.com
On a non-mmo but still space shooty shooty level there's also Naumachia which is shaping up to be all sorts of awesome.
http://naumachia.aureasection.com/
Anyway, sorry for the fanboy rant, but posts such as yours drag that out of me. I don't like seeing people drag Eve through the mud and potentially put off people who may actually enjoy the game by posting pretty innacurate statements.