Snow is an idiot, but he is a fantastic idiot. He has so much heart, so much spirit, and it shows in everything he does. Still, he's not a raging moron. Hope never told him his mother's name was Nora, nor did he tell him that he felt he was responsible for killing his mother. If you look at it from Snow's perspective, Hope is just an angry little dick. That doesn't mean he's not an idiot, though - his gung-ho attitude, while sometimes admirable, leaves you rolling your eyes at times.
Snow has some of the best lines in the game, and people often overlook that. He's also one of the best characters on a design level that SE have come up with - in that
he look like a dude. xD His voice is amazing. His theme is amazing. His clothing is just fine. His dumbass moments are no worse than those of Peter Griffin or Homer Simpson who are very much loveable idiots to many. I would say Snow fits in with them, although Homer and Peter are far less subtle.
Back on the main topic, I agree they deserve a better game, but not a different one. I think they deserve a better story in the existing game. The world itself was actually really, really interesting to me - the idea that there were Godlike creatures that could force you into completing a task and that not completing the task would lead you into becoming a monster. The focus, and having to figure it out. All this kind of thing could have been dramatised and turned into a major plot so, so much better than what we got. But that doesn't mean I dislike the game, just that I dislike how they played out the "world plot" compared to others.
Just imagine if
(SPOILER)Sazh actually killed himself, and another of the main cast actually ran out of time and turned into a Cie'th, or if Serah turned into a Cie'th and Snow had to fight her... things like that could have had a massive, massive impact on the plot. Another thing they could have done is have a half decent bad guy that anyone actually gave a damn about, let alone a boss fight against that bad guy rather than some random final boss thrown into you at the last minute.