I picked up the Enterprise-D from a local store the other day and it's great even though a bit small. And yes I'd love some scaled versions but I doubt we'd ever get them.
I mean to get the detail and keep them affordable seems to be at odds haha
http://img155.imageshack.us/img155/3...enterprise.gif
Especially if you include the smaller ships like the Defiant. Then the Enterprise-D would have to be 4 to 5 times larger. So either a REALLY small Defiant with hard to see details or a really large Enterprise-D (not that would be a bad thing).