For those who are running PCs for their home editing the newest Sony editing software, Vegas Pro 8, would be a good choice. Though the software is not as publicly hailed, it does have its followers and is versatile for all your home video needs.
It comes included with DVD Architect Pro 4.5 which is a great program that allows you to create beautiful menu systems and multi-media capabilities with a basic, drag-and-drop interface.
With a little bit of knowledge about the software and some creativity, your DVDs will look as good as anything you pick up at the nearest video store. Not only does this software offer great usability, it is also one of the least expensive video editing packages available.