If you need a good Star Trek fix go here. These guys use 3D Studio to generate images and animations that you would swear were taken from the series or movies.
Renderosity
This is possibly the best site on the web for any graphic artists. You can share your art, models, ideas, or techniques. Its just too cool for words. If you want to see the work I have posted click here.
DAZ3D
BryceTech
Need help trying to make a starship explode in Bryce. This site has wonderful Bryce tutorials; texturing, modeling, interface, DTE, and some really cool links.