You have a fair number of choices for near or under $100 video editing software for PCs. The ones I've used at one time or another are:
Magix's Movie Edit Pro 16 Plus (With Magix Movie Edit Pro (MEP) you always want the plus and the boxed versions). Website is http://www.magix.com/?L=52
Sony Vegas in flavors ranging from $44 to $600. You would probably find the Vegas Movie Studio HD Platinum or the Vegas Movie Studio HD Platinum 10 Production Suite about $95 and $125 respectively meet your needs. Website is http://www.sonycreativesoftware.com/products/vegasfamily.asp
and provides comparison table for the various flavors.
Adobe Premier Elements is the simpler version of Adobe's Premier video editor website is http://www.adobe.com/products/premiereel/
Pinnacle Studio comes in numerous flavors also. Website is http://www.avid.com/US/products/family/Pinnacle-Studio
You can often find great buys on one or the other of these at Best Buys or online B and H often has good prices).
You can download trial versions of all of these from their websites. Everyone of these editors has passionate folks who absolutely hate them. And equally passionate folks who love them. Video editing places lots of demands on all your hardware and slight quirks (sometimes due to other software) can make working with a particular video editor a nightmare.
So download the trial versions and see what you like then go for it.
Note that all of these editors provide effects like picture in picture, titling, Ken Burns effects, etc. So for $100 or so you can get capabilities that didn't exist a few years ago.
For more information about the various editors check out the HV20, 30, 40 forum at http://www.hv20.com/
. They cover lots more than the various HV cameras.