Kadena and Mildenhall are also options for certain AFSOC types.
As far as missions go, just google some of the planes and read, and then go talk to your instructors and pick their brains. There are typically a few AFSOC types running around nav school that can help brainwash guide you.
As far as pros and cons go...I'm going to go ahead and take off my "quiet professional" suit, and place my flame-retardant suit on before I piss a lot of people off just to give you some advice for your future career decisions...
Ok, if you want to fly fast, and occasionally blow shit up, sit around talking about how awesome red flag was, go to the pointy nose jets.
The future of war is in special operations. It's not to say other airframes don't have their place...they do, but this isn't their type of war, and this type of war isn't going away anytime soon. There are only so many problems you can solve with a bomb. The administration has made their top goals to expand special operations (read Gates' speech about FY10 defense budget). Commanders are shying away from liberal CAS use: http://www.airforcetimes.com/news/2009/12/airforce_airpower_121209w/ And the public is slowly growing tired of grand public conflicts...so those in power turn to those behind the scenes, to walk amongst the night and get the job done!
Gaining ground in this war will take a different approach, a different mentality, and a different soldier. This is where special operations comes in. Special operations requires a vast skill set amongst all the branches in order to accomplish the awesome missions it does day-to-day. Sure a terrorist may stay awake at night from the roar of a B-1 at altitude, but what really makes him lose sleep is the fear of the burly bearded snake-eater in the dark carrying nothing but a knife and a polaroid of his fugly face. (see pic) In AFSOC, we are the air component that helps make that happen.
You will meet and work with legends that could never be recognized for the missions they've hacked or the history they've rewritten. You will develop an unspoken level of trust between you and the user because you both know and appreciate each others' hard work. You'll go home at night in awe of some of the people you work with and you will strive to emulate the sheer dedication and tenacity of those around you. It will breed an unparalleled mentality to bend over backwards for the user, and to never falter on your end of the contract.
THAT's the AFSOC lifestyle...
Choose wisely!