Pretty much every 3D console game will have a percentage of torn frames, on 360 or PS3.
But I think you must be (unfortunately) very sensitive to get irritated by them, considering they are generally so few and far between. It seems you're irritated by alot of stuff the HD consoles have to offer.
By the way, I can empathise, and I feel sorry for you, and how the tearing irritates you. I'm however pretty uneffected. Maybe it's the size of your TV that makes it more noticable... I'm unsure, but it's sad that you won't be able to enjoy all the great games having tearing irritate you so.
On the other hand you could always look up games on say, the lensoftruth.com, for multiplatform at least, they do reports on the number of torn frames for titles, alongside FPS and other statistics. Other technical sites like Arstechnica also do performance anaylsises for some of the exclusive titles, so you could look at those and avoid those with the more severe tearing.
Just curiously, do you know the specs on the TV your using? It's just a guess but maybe a TV with a faster response rate would make tears less visible, the response rate on mine is 1ms, and I could count the torn frames I've seen (if we skip out Call of Juarez which tears constantly).
