As nice as it may be to have a convenient airport from which to fly, and possibly train, it is a costly luxury. If an airport can operate and sustain itself, while keeping user fees low, how nice! But the reality is that airplanes use a lot of costly space for their operations, and GA pilots are generally not eager to pay the costs in proportion to the use of space and services they need.
I fly over golf courses embedded in the city, on really expensive property, and again, lots of space for low density usage. But, from what my golfing buddies tell me, enough people will pay immense sums to use that special purpose property. I hardly see most GA pilot/owners happy to pay tens of thousands annually to be a member, and use the airport facilities, but there seem to be enough golfers to sustain this, and then a hundred a round on top of that!
A local to Toronto flying club is nationally known for being the only Canadian flying club to own it's airport, and it's a beauty. There are fees, and they are reasonable. Most other Toronto area airports have either closed, are forecast to close, or have welcomed in more commercial operations, which squeezes GA into less free and economical operations.
Unless you own the property, you're at the mercy of the person who does - you have to hope that they like aviation more than making money!