In general terms, it all depends on your budget ! It is best you do some research online.
Your choices kinda go like this :
1) Expensive, great graphics: RealFlight G3/G4, Phoenix, Reflex, FS One (US$160 to US$200). Some of the them come with their own transmitter with a USB connector to the PC. Most of them are protected, so that you have to use some kind of hardware that you get with the sim itself, so they may or may not work directly with your existing radio (downloading the software from some place is not enough!).
2) Cheap, pretty good, average graphics and physics: Clearview (US$30). Should work with any transmitter that can already connect to a PC (via serial or USB ports). More information at
http://rcflightsim.com. Another one in this category is the E-Sky Flight simulator (US$20), which comes with a simple radio :
http://www.raidentech.com/e4chflsitrki.html3) Free, bare minimum: Flying Model Simulator (FMS). This forum discusses the hardware you will need to get it to work with various radios :
http://n.ethz.ch/student/mmoeller/fms/index_e.html. Getting/building the connection hardware to get your radio working with this is too much trouble, so this is not a good option for beginners.
4) You can find some all-in-one deals at local hobby shops where you can get a cheap plane/heli, controller, cables to connect the controller to the PC and low-end sim software for like US$125.
I would recommend one thing though. "IF" you are planning to be in the hobby for the long run, getting a good sim certainly helps. Practising new moves on the sim greatly improves your flying skills. Most importantly, it prevents costly crashes, and the money you are saving by not crashing pays for the sim many times over.