I've dabbled with sfm for nearly a year now, and I'm getting into working with demos. If you'd be willing to try me out to work on a slightly more flashy frag video I don't think you'd be disappointed. I wouldn't need pay. The opportunity to work with really good demos is pay enough.
Though if you want a simple video I'm sure afterglow could do a really good job.