Ok Tim,
Here's the deal.
There is no editing software for under 100 dollars that is going to give you what you need.
Premeire is something you might look into... but at the price of premeire, you should just get something else instead.
Seriously consider the Avid line of products.
Avid Express DV is the lowest end software they sell, it's packed with effects and professional options...
however, it is rather limited.
If you're interested in looking for more expensive software than Express DV... look into the next step up, the Avid Express and Avid Express Pro software.
Basically, here's the deal.
There isn't a program out there that is going to give you what you need for under 600 dollars.
Avid Express DV sells for $695.00
Avid Express Pro sells at $1,695.00
The mojo addition to Express Pro, which you would need if you intend to do really heavy effects, will run you another $1695.00
So I suppose it's really going to be up to you to find what you need.
Effects are not cheap though... and you may find that even the Express Pro with Mojo might not provide what you were hoping for.
There is a complete Express Pro Studio that runs around $6995.00 and it'll give you a lot more options... however, it's still not going to give you the truely film-like effects.
Hopefully this helps a bit...
if you want to know some more about Avid systems, I've got some expreience and done lots of research in that area...
If you think this didn't help very much... please give me some more specifics...
I see that you wouldn't mind spending a couple hundred dollars... and that you're on a windows platform... however, the more you tell me (speciffically) what types of effects you intend to do, the better I can answer your question.
For instance... if you just want to do basic color correction... it's a standard option on any professional software... however, if you want to do something more advanced... you may not even find it in the Express Studio package... and from there, the editing systems sky-rocket in price.
Hope this helped... but if it didn't... give me more info & I'll help out all I can, and I'm sure everyone else on the boards will help too.
Happy Editing!