I love CSS, I hate frontpage!! Lots of pages on my site were not displaying properly in firefox. Used css to style all of the text and now the pages all look sweet. This was a big issue because i did actually lose an advertiser that was paying quite big money when he saw a page on the site that was displaying correctly and I couldnt explain it. All hail Dreamweaver!
Well, Dreamweaver creates code that is much easier to edit by hand later with a simple text editor, that's for sure.
Dreamweaver 8 certainly is better, with much better CSS support, but it still has a propensity to add extra code that is really not needed. It also writes CSS documents in long hand. A good companion to DW8 is Top Style Pro which you can use to clean the CSS code up, if you aren't adept at doing it by hand in a text editor or DW8.