I do somewhat agree with the OP.
It would be nice to have some dedicated content for smaller ships, I think small pads at certain outposts or planetary bases would be the easiest way to implement this in the short term.
Further down the road you could start to get passenger missions for those not looking to attract attention and want a slightly more low key transport vessel, escort missions where the size of the escort ship is restricted to small pad ships and of course smuggling.
I have no real desire to own one of the big ships for a number of reasons, time and cost being the biggest but I also value speed and agility over size and power. I love the FDL for combat and the Python for it's multipurpose abilities but I feel the Cobra III, the DBS and the Vulture are just more fun to fly.
All that being said I might get a conda one day when I eventually turn my attention to getting Trade elite status and find the Python to be just not quite big enough.