Dreamweaver's ok...
But a bit bloated, in my opinion. It tries to do everything and to some degree it succeeds, but at the expense of not doing any one thing particularly well.
Nobody who's serious about knowing their stuff uses Design View, because it outputs bloated, table-based layouts. I've used it in Code View and the autocomplete is pretty good, but nothing you wouldn't get in Aptana.
What is handy is the file management, especially since CS4 where they included Subversion integration.
The ability to FTP from within the IDE is also good, but performance doesn't stand up to a dedicated FTP client (my favourite is FileZilla).
For backend stuff I tend to use Netbeans or Zend Studio for Eclipse.