i use sony vegas pro 9 and adobe after effects....i personally prefer sony, but after effects allows you to do more things. However, it doesnt accept the file type my camera uploads to...so i have to convert to .avi...
You can't win if you don't try.
Final Cut Pro X is pretty nice, it's almost as simple as iMovie (in my opinion), and it offers some great effects.
Adobe After Effects Cs5 is crazy, it has so many effects (Way more than FCPX), but it is just very hard to get used to until you mess around with the program for a while. . . just have to get used to where everything is and how you use certain effects basically