Can't wait for this book, esp. since my attempt at organzing people to put a d20 Modern version of Stargate months ago failed miserably
So far, the sample info on the official website has me quite stoked since it seems like the writers know what they're doing, esp. with the variety of situations described for using the DHD.
...although I gotta ask: the sample team leader was a Falcons cheerleader AND knows belly dancing?

Someone's putting the high roll in Charisma for their female characters again...
Also looking forward to the "season books" which is an excellent idea expecially since it would allow "new crunch" to be added into the campaign if a certain timeline is followed.
Hey, how about including a poster that outlines the symbols on the DHD? This way, sadistic DMs can make their players actually dial their way home...
Since it was mentioned that the book might be available by Gencon, does that mean we can expect them in store around that time?
One thing I'm looking forward is to see how the rules will resolve the "Zat" issue and it's one-shot-incapacitate/two-shot-insta-kill effect that might make it an uber-weapon.
Finally, will there be suggestions for GMs on how to convince players to actually call another player "sir"?

(the BIGGEST obstacle in my mind

)