... I now have CS6 and see that it includes video. With only a quick look at CS6 video capabilities, I am uncertain as to whether CS6 or PE 10 is best for me.
Can CS6 incorporate pans and zooms on stills added to video? Variations in transitions?
What do you mean by CS6? Assuming you mean Adobe Premiere Pro CS6, yes you can do all that and more. It has all the basic transitions, with total control. Plus you can also buy plug-ins for anything.
I'd like to think that CS6 is better for me than is PE10 but would appreciate any discussion.
Only you can answer that, and you can't until you try both and see what you're more comfortable with. Hope this helps.