I played Top Secret a bit during the day. It was fun but we weren't really doing much spy stuff, just doing combat. I prefer doing things that are less combat oriented in my RPGs, like here's a weird scenario, I don't have any specific idea of how you would get past it, be creative and do something.
I've had ideas for a few assignments, and I've done what I can to make sure that there's a mix.
For example, one mission would have the party assigned to serve as bodyguards for a prominent Hillary Clinton-type politician; she's gotten death threats from a less-than-successful ex-boyfriend who appears to be jealous of her success, and there's reason to believe that the threats are credible. (They really aren't. If the party is pro-active enough to investigate the ex-boyfriend, they'll learn that he joined the Peace Corps and left the country three months ago. The politician actually hired someone to forge the threats as a way to get some more face time in the media while shaming the guy. Exposing the matter will result in the politician being forced out of office and the ex-boyfriend getting rich off of a book deal.)
Another mission would have the party sneaking into North Korea to rescue Raccoon, a South Korean intelligence operative who was captured and is being held under guard. Not only is the prison facility itself remote and heavily guarded, a North Korean base with a HIND gunship, several transport helicopters, and two platoons of air cavalry is on standby in the event of a jail break or direct assault. (In reality, nobody at the base seriously believes that an attack will come and so they aren't as alert as they should be; the party can easily steal the HIND and use it to blow the prison's garrison to pieces. Oh, and that's not Raccoon in there, either; it's a North Korean document analyst and intel official who was framed by the real Raccoon. The party merely has to attempt the rescue to make the government think the official is the real deal so as to throw them off the trail of the real Raccoon, but if they succeed in "rescuing" him anyway then the South Korean government can easily interrogate him for information later.)