I do digital video editing for my job, so if I’ll be happy to answer your questions as best as I can.
Getting an adobe production pack is an excellent idea if you’re willing to spend some serious cash. Also, although it’s none of my business, I wouldn’t suggest that you look into a production bundle unless you’re very, very serious about video editing. It’s worth the money, only if you choose to throw yourself into production. For video production as more as a hobby or interest, I’d suggest that you seek out a slightly less expensive set-up with a more generic user interface – such as Pinnacle or a LE version of Premiere (I’m pretty sure they make one). But if you’re determined to become a digital editor, then an adobe production bundle is the way to go.
First off, I love After Effects. I've been using it for about … two years off and on, and pretty seriously the past couple months. I’ve recently been experimenting with Particle Playground. It's extremely render intensive, and I have to turn off the RAM previews so my machine won't choke and die (yeah, yeah, it's on a windows computer) but the effects are worth it. It's such a powerful program that acts much like photoshop does - you're limited only by your drive space and imagination. Once you understand the program’s initial functions, they can be manipulated so that just about any effect that you could want is possible. The basics can be figured out fairly quickly, and you can do some impressive stuff just by playing around for a few hours. This is assuming that one is familiar with adobe and how the interface and tools work. I’m currently working with version 5.0, but I’ve messed around a little in version 6.0 and it’s very nice. As for training, I'd suggest Total Training for After Effects ... whatever version you're looking into. Total Training is pricey, but the end result is worth it. Don’t expect to be amazed by the tutorial projects, either. They have little to no inspirational quality, but they always get the effect or technique demonstrated effectively and clearly. And like you mentioned, the cost is way up there, so I do not suggest getting these unless you’re completely serious about editing.
Ok, Premiere. If you understand the general adobe interface, the basics of Premiere should be a snap. There are lots of renders involved, even for a simple cross fade. They did fix this in the latest version – 7.0. Most of the general activity can now be put together and played back in real time – and that is one of the biggest perks about digital editing. Render times can drive you insane sometimes, especially if you just want a quick view of what you just put together. As for not being able to capture video … that could be so many things. What kind of capture card are you using? Which version of Premiere are you using? What are your capture settings? Are you trying to capture with firewire, or through rca? The list of questions could go on and on.
As for demos, I have none uploaded. My most recent ones are for a missions promo, so there’s a lot of maps and spinning globes, and text effects. I don’t use AIM either. I’ll see about getting something uploaded, though.
For public domain music … there’s so many places.
http://www.onemusic.com is a good example of royalty free music.
http://www.elitemusic.com has good video stuff in general
If you’re not in a huge rush, I’d pick up some magazines on digital videos and do some research.
http://www.dv.com is a good place to check stuff out.
http://www.videomaker.com/scripts/index.cfm the magazine that goes with this site is pretty good. They cover other equipment such as cameras and lighting kits as well as editing programs.
Wired is a pretty good magazine, but it covers electronics in general, to the articles that might help you out may be a little hard to dig up.