I use to to Studio 7 and 8 before I purchased Liquid Edition, and then moved on to Final Cut Pro. But, for an application for less that $100, Maybe the lastest version of Studio might be the way to head, or Sonys Vegas. I've never used Vegas, but I hear good things.
As far as Studio goes, it was a littel buggy for me (cashed randomly especially with big projects) but the interface was simple and I made several wedding, vacation, and goof-off videos....
I would just recommend DL trails of all the suggestions mentioned in this thread.