Ooh, tough one. Halo: Combat Evolved is one of the hardest games i can remember. I couldn't ever beat it. The flood always slaughtered me.
I know there are harder games out though. I've never played any Mega Man games, but i heard they're some of the most difficult.