Sony Vegas is another option to look at. There are a few different versions. I've used Platinum and Pro. Platinum is good, Pro is a bit better and has better support for things like still timelapse video and has more features. Price isn't bad. It's a reasonably popular and full featured video editing app.
If you want really cheap, look at
VirtualDub (Windows only). It's a free, open source application and there are a large number of plug ins available for it to give it pretty robust editing capability. And hey, it's free.
If you're an Apple user there's Final Cut.
Pinnacle is the 'cosumer' division of Avid and has what's supposed to be a decent package. If you want to shell out around $2500 you could go for the Avid option.
Adam, while LR3 appears to allow you to import video in so much as it will transfer the video clips from the memory card to folder on your computer, it really doesn't do anything more than that. Does it? You can't preview the clips in LR or work with them in any way, can you? Are you able to keyword video clips in LR 3 or otherwise manage them in ways similar to stills?