Hee, so you're saying you're a follower of the Peter DeLuise school of blowing shit up. Gotcha. Well, I could be lazy and tell you to wander through my "stargate recs" tag, but here's some good highlights.

Chance (http://community.livejournal.com/sg1teamficathon/7265.html) by Mitai. It's definitely a teamy adventure where everyone plays a great part (okay, Daniel spends most of his time pretty whumped, poor fella, but the Sam love is awesome) Actually you should give any and all of the fics at the sg1teamficathon a go through. They're starting it up again. If you haven't signed up for it, at least you'll be able to enjoy the fic that comes out of it. In the meantime, enjoy the awesomeness of the first one.

Travelling One (http://homepage.mac.com/traveller1/travelling-one/) focuses on team or Jack and Daniel friendship. Her stories are usually adventure with a twist. She likes to play with more unusual aliens or morally ambiguous tales (I say it's Twilight Zone like in that respect). She's my favorite SG-1 gen author overall.

Double Trouble (http://moonshayde.livejournal.com/237143.html) by moonshayde I'm totally unbiased here, because this fic was partly inspired by my icon (pictured above). Moonshayde's gen fics are very plotty character driven adventures. When you really want to go deep and have a lot of time, give her "A Priori" a try (written before Season Ten and without knowledge of spoilers, it's eerily prescient in some ways to things that happened).

These are just ones I'm thinking of off the top of my head that are "adventurey". I know I'm missing others.