Hi HABailey, it sounds like the sim is actually doing the right thing and that you have a setup problem with your "real" plane. I would guess that you have too much right thrust built into your plane(or too much right rudder trim). All planes(before people start picking at this, I mean single engine prop planes) should yaw left when full throttle is applied, requiring right rudder to keep them straight. A sim can be made to behave in the same way as your plane, but you'd have to create a custom version of your plane in the sim, and change the parameters for right thrust to match yours. Then they both will react in the wrong way.

To answer you question in general, RealFlight(G2/G3), Aerofly Pro(regular or deluxe), or Reflex will fly normal planes in a very realistic manner, with different people having different favorites for a variety of reasons. Typically the general consensus is that RealFlight and Aerofly are the best plane sims and Reflex is the best helicopter sim(as far as reality), but you'll find plenty of people that disagree. I've owned RealFlight G2 and G3 and I now have Aerofly Pro Deluxe, and all of them are very capable sims that will serve you well.