So, is this on the level of Limbo of the Lost bad, or is it on the "it's so bad it's fun" level that games like Corpse Killer or Ground Zero Texas are?

Dude, can I join?

He's an idiot. And he's not half as funny as he thinks he is. But in this case he does clearly say "Deadly Premonition is bad. By most standards it's terrible. " So it sounds like he's accurate. And he agrees with IGN.
Giantbomb on the other hand clearly don't read reviews, because they say it's receiving mixed reviews, when both reviews actually say it's "terrible". That's not mixed.
PS/ Wait, the characters in heavy rain have sex for no reason after going through lots of scary un-sexy shit together? Didn't they learn anything from indigo prophecy????

That's the Giant Bomb community, since those pages are basically Wikis, and at first glance it would look like Destructoid scored it high. Also, Sterling's Twitter feed shows that he really loathes Heavy Rain:
"@metacritic Hey guys, any reason why our Deadly Premonition review was removed?
If it's any consolation, Heavy Rain's plot becomes so absurd and stupid that the freezes may be a blessing.
Considering how arrogant David Cage can be, did you honestly think the credits would be skippable?
A game maker who wishes so badly he could be a movie director.
Well, I know who the killer is now in Heavy Rain. It's so fucking stupid, i'm now trying to get the rest of the characters killed. Sooo bad."
And perhaps the most telling Twitter post...
"A fucking joke? I fail to see what my review did wrong. I gave an opinion and a score that reflected the opinion, did I not?"
He's a biased prick who thinks he has a funny bone. I can't stand him.

Biased about what?

Himself. He thinks he's the most intelligent, sarcastic writer there is, and people who disagree with him "don't get it".

Its a lesson to us all: READ REVIEWS; do not rely on scores. There is more score idiocy on the internet, people need to read reviews and stop depending exclusively on scores and stop whining when the flavor-of-the-month gets a 9.0 instead of a 9.5.
And I thought the review was a hoot.

Sex is bad? I like sexy time as much as the next one.

I completed the game (FARENHIET/INDIGO PROTHECY) just now and the ending makes no freaking sense. Espically the sex scene, "I LOVE YOU EVEN THOUGH NOTHING HAS BEEN SHOWN THAT WE HAVE A RELATIONSHIP".
Eh, Destructoid seem to be very good at trolling. I'm suprised people listen to what Jim Stirling has to say. Although the video "F...K IN THE COFFEE" is hiliarious.

you like sexy time with undead murderers that you met yesterday, in sub zero conditions?
er... excuse me... i just need to go and do something... elsewhere...

Can somebody explain what the F...K in the coffee video means? None of my friends know either...

Hahahaha, you have a valid point there.