The bottom line is, no matter what program you use, WRITE THE CODE YOURSELF!
So if you are using Dreamweaver for example, use the "Coder" setting as opposed to the "Design" setting. Its fine to use these programs, but make sure you learn HTML and whatever other language and do it yourself. The main problem with Frontpage or any other program of that nature is, if you use the automatic page builders, they will add in a bunch of crap code and thats why the site looks like shit.
Like the old saying goes, "If you want something done right, you have to do it yourself"