I found that Coda was incredibly useful for PHP and flat HTML/CSS and hardly useful for anything else.
It's much better for PHP and HTML/CSS. It's geared towards that. For other languages it's just as powerful, but it doesn't have the same one-window-does-everything aspect to it.