elmo -- btw, there will always be some sacrifice for lower-end.
The solution is to let people after they've purchased it be able to upgrade to better stuff after release when we have a better idea of the purchasing demographic.
For instance, GalCiv II may be the first game (certainly that I know of) whose textures are vector based rather than raster (i.e. when you play Quake 4 or some other 3D game, their textures were probably made as bitmaps in Photosohp or whatever). In GalCiv, ours are vectors so we could easily have 4096x4096 sized textures on ships which would give it amazingly graphics.
But for compatibility, the textures are 256x256.