The best I've used in terms of usability has probably been ER studio, but it's not cheap. I've used Designer but it can be over complicated, depending on what you're trying to achieve.

Currently I'm forced (and I literally mean forced!) to use Visio. In case you hadn't guessed I'm not a big fan of it.