As with most answers to poker questions, my best answer is 'it depends'.

I actually want a hyper agressive player (the likes of Gus Hansen) to my left. I know he's there, and I'm not going to raise without a very premium hand, and he knows that. So a check raise becomes even more powerful in this situation. This, though, is much more the exception than the rule.

Generally speaking, as it's already been said here, you want agressive players to your right so that you can better gauge your hand vs. the raise they just made and what's in the pot.

The check raise though, is an invaluable move against agressive players. Even if they call your CR, and come out firing with a flop raise, reraise them again with a solid hand and they'll likely cut their losses and go away.