Alright guys, since I am greedy and want to see more units here is a list of sites that provide free models that you should be able to turn into Civ4 usable units.

Mostly star wars stuff - http://www.gerf.org/~nixon/
All star wars stuff - http://www.dylanbeattie.net/starwars/ships.html
Too many models to describe - http://216.165.190.200/asp/meshes.asp
star trek models - http://www.tgeweb.com/object-archive.htm
models from movies - http://members.ozemail.com.au/~dproc2/index.html
SCI-FI models - http://www.scifi-meshes.com/meshes/


EDIT: added more links

daleks, goodie!

Awesome find TheLopez. More, more, more!

I'm working on it. Currently I am trying to find free battletech/mechwarrior mech models.

Hey, these are great! Any idea of the poly count on them though? It looks high...

Well, Dual looked at a few and said that their poly count is high but that it can be reduced.