I flew to "Toronto Hamilton" in summer. 3 hours outside Toronto and no public transport connections. My Toronto friends had never even heard of it. Makes Stansted seem very central in comparison. On the plus side, it was so small and shit that the front door to the gate was a 1 minute walk.
Or airports that force you to take a long meandering stroll through Duty Free.