Yeah, I played the original through in its entirety (Metal Gear Solid) and it was ok, not great. The real issue is that watching/reading the story is like 60% of the game and it's just not very good to me. When I say this people usually tell me it's over my head, which is just a way of feeling superior because it really, really isn't that complicated or deep. I get what it is conveying, it just does not do it very well. I played parts of 2 and 3, neither seemed any better. I remember some extremely long dialogue in 2 about love while you're in the middle of a mission my friend was playing, it made me literally want to scream.
If the gameplay was amazing I could get over it, but it's really not. Splinter Cell 1, 2 and 3 did a much better job with similar gameplay.
I'd say the best PS3 games at the moment are Ninja Gaiden Sigma (Ninja Gaiden Black on the original XBox is better, though), Resistance: Fall of Man, Uncharted 1&2, and God of War Collection (haven't played GoW3 yet but I'm sure it's just like 1&2 and therefore one of the best games on the platform).
Ninja Gaiden and God of War I have no interest in, those wacky-wacky combo action games do not appeal to me, I played God of War 1 and was bored within an hour, never played it again. Resistance Fall of Man I liked, I played it early on when I had a PS3 briefly. It was very Half Life in a lot of ways, which I enjoyed, and the graphics had a clear and crisp look to them rather than muddy detail like a lot of console games. I wouldn't call it a great game though, and I wouldn't buy the system to play it again or its sequel, which I heard was not as good.
Uncharted 1 and 2 goes without saying... those, Demon's Souls and FF13 are the games that make me want a PS3.