You asked, so here goes...
I don't actually do CG(I am in awe of you all who can, though...). I only make physical models.
What i am, however, is a big Stargate fan, so i have tried my hand at a few ships. I do hope this is not out of place here.
I recently made a 1/144 scale master pattern for an F-302 kit(It will be sold as a kit, and
is about 13cm across).
Also(For modellers who prefer big), i did a
1/24 scale master
of the 302.
Slightly smaller, i have made a 1/2500 Daedalus
to be sold as a kit shortly(About 17.5cm long, before adding the antennae at the front).
And(I saved the best for last...): I have been asked to make a 1/350 Daedalus which is destined to become a model kit also.
It's going to be very big, however, so
start saving up, guys...

bar.