Another vote for Imovie
I guess for easy lite usage on the PC side I'd also recommend Pinnacle Studio. I don't know about 8, I've only used 7 before. I hear 8 has alot of issues and problems. Still, its one of the top newbie video apps for PC and a 5x times easier then using something like Premiere (but also 5x more limited). If you are just planning on doing some mild work, I'd stay away from serious programs like Premiere. You'll invest alot of time and money.
For more money Avid Xpress is much like Final Cut. It gives you alot of power in very easy to use interface. The learning curve is steep but the starting curve is not...? Meaning you can get started on basic functions fairly easy, but there's alot of headroom for advanced features. They also cost $1000 too which is not for the light user (You can get them cheapr though through developer or education discounts).
Still, we're talking about video editing. Its a huge spectrum of information. As a non serious/non professional user, its hard to know what you need and what you don't. If you don't want to be reading 3 hours a day on the subject, I suggest you keep it simple, focus on a task and what you need to know for that task. For instance you want to know how to import from a DV camera and burn DVD's or VCD's and add a few small effects like titles and transition fades. Try to keep your tasks light and focused at the moment because you'll be surprised how much information there may be on something that you thought was simple. Even the model camera you may have may be very problematic with alot of software or capture hardware.
You should think about what your primary video editing goals are and then ask what equipment and software best suites it.