The problem I had with the shaky cam in the Bourne Supremacy was that during the fight sequence in the house in Berlin, and during the final car chase, there were moments when I just could not see what was happening. What's the point of having fight choreography and laying out a decent car chase if you're just going to ruin it by having the camera zipping around all over the place for "dramatic effect"? It almost ruined the film for me, though it probably doesn't look as bad on the small screen.
I think a Watchmen movie could be good, but I don't see how they're going to do it without making it pretty long and/or cutting a lot of stuff out. I guess they'd also need to get an actor who's relatively unknown to play Rorschach in order to keep the surprise about his identity, which is unlikely as he's one of the main characters and the producers would therefore presumably want someone big in that role.