Word Bikdu (AKA [AE] 3721)

I didn't know you had dabbled in Hammer. You should try making a full blown map as' a project' for your summer break (we could test it on our SGTLS server). If I had the time I would be a level designer for sure (I did do it back in HL1 days)!
As far as including SGA & SGU into the mod this could kind of be done by the map makers in the sense that they create maps specifically based on episodes from them.
The only issue though would be the star gates and DHD's though as it would be a ton of work to make three sets of them for use in any one mod.
I could easily see a map to take control of the Destiny being done for any stargate mod. Shoot it might have already been done in another mod. I know Garry's Mod has got a good amount of active star gate fans that are creating stuff for it all the time.