I have two possible answers.
FlightGear is an open source flight simulator that provides many scenery packs for various airports and locations. As most open source projects, the software and expansions are provided free of charge.
For visual superiority, I would recommend X-plane. The demo is free, and I believe most would consider the full product worth the cost.