Kline: I previously used the big, expensive tools quite a lot: ERwin and ERStudio. But now I use inexpensive or free modeling tools like Model Magic and SQLDM.com.
Davidson: I agree with Kevin. ERwin and Embarcadero are fantastic and have many features, but SQLDM.com has become a favorite because it is a solid portable tool.