The best mid-range, non-sgi / non-mac video program I know of is Vegas. It started life as a Sonic Foundry program before they sold all their desktop software assets to Sony. VERY powerful and you used to be able to download a free trial. If not, let me know and I can post it somewhere for you (the TRIAL version, that is).

Or, you could pay Apple a bunch more and get a pretty interface.

Or, you could pay Sgi more and get a pretty box. And a pretty interface. =^D

Either way, if you're stuck on a Win-tendo, Vegas is the way to go IMO.