I quit watching at the end of season three. I don't know why I hung on for that long - I just kept hoping for it to get better or at least show some of the zing the first season had. But it was just one idiot plot after another.
The only way that this show could get me to watch it again is that scene one of act one of S5 Ep1 is the bloody and lingering deaths of Peter and Mohinder. And as far as Hiro goes, he would have to morph into the guy we saw in S!, the badass that stopped the subway train, had his hair tied back, carrying a sword and was actually confident. Show me that guy. In fact, have him kill Mohinder and Peter for crimes against the viewing audience. I'd buy that DVD.
From what I have read about the script, the prologue is still the same: three of The Black encounter the Others beyond the Wall. There's your fantasy element right there. And of course, the pilot ends with Jaime saying "the things I do for love". Which of course is the point where your average HBO viewer says, "Man, that was intense. I have to keep watching this."
Downey as Sherlock Holmes might be interesting but I am much to caught up in casting rumors for HBO's A Song of Ice and Fire. AICN has a rumor about Peter Dinklage seen in an elevator at HBO, which is making many heads assplode in happiness at some fantasy forums.
The problem with Batman is there aren't that many great villians and you just lost the actor who played the best one. Now I would love to see Catwoman played by an actor in her 30s with some gravitas but I wonder if it will happen.
From the LOTR movies, the deaths of Boromir and Theoden are as gut-wrenching as anything I've ever seen in a non-genre film. I suppose that some would nitpick that this is fantasy and not science fiction but hell, it's a stretch calling Star Wars science fiction.