Sony Vegas is, IMO, the best and most user friendly editing software out there. You can get one of 3 different versions: http://www.sonycreativesoftware.com/...egasfamily.asp
I personally have Sony Vegas Movie Studio Platinum 7, but may upgrade to Pro 8 soon with the good deal of $130 for just Vegas Pro 8: http://www.bhphotovideo.com/c/produc...o_8_Video.html
If you need DVD architect, then it would be cheaper to just get Movie Studio, or Movie Studio Platinum.
I've used Adobe Premiere, supposedly the best of the best, but it crashes so much and it's not very work flow efficient, at least for me. I think I've only had Vegas crash on me twice because it didn't like a file in the 1.5 years I've used it. Don't go with the lesser names like Ulead and Magix, or whatever they are, they are basically a Windows Movie Maker with more features, and crash often. If you are tight on cash, get Vegas Movie Studio.