I am always on the hunt for cool Stargate downloads. If you ever come across something awesome, I hope that you would share.

The most recent Stargate upload on MTS are Naminator999's artfully done items:
Stargate Command Briefing Table
BC-304 Starmap
BC-304 Pillars

Of course you can't have a Stargate lot without an actual Stargate. How about we start with xanathon's version:
Operatable and Animated Stargate
Stargate DHD
Stargate Recolor by martinecek15

We must not forget about the clothing. Gonkski222 made some fairly nice threads for the SG1 team to wear:
Everyday Wear
Swimwear, Undies and Athletic

I realize that this last link is not from MTS, but I just had to add it anyway:
Drivable F-302 by ocelotekatl.

For members of the SG1 team, you can check out this link:
Nextor's SG1 Collection
The collection includes Jack, Sam, Daniel, Teal'C and Dr. Fraiser. It also has a MALP, a Jaffa staff weapon and a zat.

For the Atlantis team, you can follow these links:
Primary Characters
It includes Sheppard, McKay, Weir, Teyla and Ronon.
Supporting Characters
This set has Beckett, Caldwell, Keller and Zelenka.

What other Stargate treats have I missed?

If you were a fan of seasons 9 and 10 of Stargate SG-1, then you are also going to need Cameron Mitchell and Vala Mal Doran. Well... uh... technically these are not Cameron or Vala, but I won't tell, if won't tell.

Here is Cameron Mitchell, also known as John Crichton on Farscape.
This link is for Vala Mal Doran, or Aeryn Sun on Farscape.

The big ol' Stargate is my favorite -- I built a museum lot once, and put that in as the centerpiece. It was right in the middle of a bunch of Egyptian artifacts. It was awesome.

Here's a link to some outfits made by V1ND1CARE. I use these Special Ops uniforms on Teal'c in my game.

Here are some Alien starship walls.

I also came across this group of Wraith characters
The set includes a Queen, Scientist, a Warrior and Michael.

If you've started on Stargate Universe characters, you can get Ronald Greers desert uniform.