Not sure where we live is that critical, well at least for me.
When I want to fly to Scotland to see family, then my choice is either BA via Gatwick, usually the cheapest, or Ryan Air via Stansted, poor connections and a dreadful airport, or Easy Jet via Gatwick, cheap but lousy airline.
When I want to fly to London, I choose BA as I like the usual early morning flight from Gatwick (sometimes 6.00 or 8.00) but my wife prefers a later start which means Easy Jet and I grind my teeth.
For us in Ste Foy, Bergerac is convenient, so London City might be attractive when I am on my own but if we fly together, then we stay with the in-laws who live close to Gatwick, City Airport would be a pain in the butt, as with Stansted, so we choose Bordeaux and etc.
A long winded answer to say, we choose the airline and thus airport that meets our needs for the specific trip. Adding BA to the mix for Bergerac is another choice.