Microsoft FrontPage has been replaced by Microsoft Expression Web and Sharepoint Designer, which are both free downloads from the Microsoft site.
Sharepoint does not support anything other than Microsoft Windows Server web servers - which 99% of non-corporate web hosts run and which 99% of customers have no interest in.
Expression is not WYSIWYG, and thus cannot be compared to Frontpage. In addition, Frontpage support Linux web servers without issue, Microsoft only moved away from support for Linux in an attempt to remove the competition - did they really think that Frontpage was the reason we in the industry, all use Linux? Muppets!
As for UI improvements in 2007 - that is purely a matter of opinon. For those of us who have been using the same basic interface for over a decade, changing over to 2007 actually makes some simple tasks much harder to do - Microsoft try their very best to implement changes and tweaks on the UI, simply for the sake of making software look different and new, and it is NOT always for the better (look at the programs list in Vista vs XP/2000/98 for instance).