Yes, the Vomit Comet I am sure is a rewarding job,(pingers excluded, no subs in desert!!!) sitting up there at FL nosebleed, watching it all on tv eating through the remains of the defence budget.
However if you really want to be involved at the sharp end, why not fly at 50ft, 150kts with some guys with blanked out eyes, to drop in for a bit of late night 'door knocking', with fair chance of a bit of action along the way then go for rotary.
You may not be kicking down doors yourself but it is the closest thing to it in the NCA world! You can be a part of it or sit there and watch it pass you by!!!!
Nuff said.