I've had the dubious honor of reviewing FrontPage 2003 for a magazine, so I have my own copy. You can make "pretty" websites that work really well with it; however, the code that it generates is poorly optimized and highly presentational, relying on nested tables, spacer GIFs, and other late '90s techniques.
Having said that, "Code View" in FrontPage actually works really well. It's quite a good text editor, as a matter of fact. As a WYSIWYG tool, however, it is a poor substitute for Macromedia's Dreamweaver.
Keystone Websites | si-blog