In FSX a very basic auto generated global scenery was available to everyone, that could be expanded with high detail add ons. But even 10 years ago MS had to charge 60 $ every two years to finance it.
I don't think that there will be perfect solution for DCS, that pleases all groups, anytime soon. It will all depend on the development cost of future maps. I can imagine that workload per map could decrease drastically if they can auto generate large portions from geodata and once they have 3D object libraries for various time periods and regions.
Also DCS customer base could expand together with more varied content becoming available. Thus more sales per module could allow for lower prices or subsidized maps.
I will almost certainly buy many more maps than aircraft in future. With study sim level F4U, F/A-18 and Harrier coming I will get almost everything at that level I always hoped for.
Already in FSX, without any combat, I enjoyed it much more to simply explore the world from the air than learning to master new planes all the time.