The only experience I have is in small planes (Cessnas mostly) but in my opinion:
Airliner=No Way Single engine prop=Possibly. I only ask two things of you. Don't do the experiment in any airplane I own and don't expect me to come along as a passenger. :o

More seriously, MSFS is a good training tool for a small plane. The operation of the Cessnas is very close to real and even closer if you follow realistic procedures all the way through the flight.
Since I started in real Cessnas I found little trouble at all in the sim with those. The panel, instruments and flight characteristics were very close to real life. Procedures are a different matter. I've done things in the sim that would get my certificate yanked in a heartbeat in the real world (hey, it was fun) but overall the sim provides a decent experience for the small stuff.
Airliners are a completely different matter. Even an experienced Cessna pilot would be overwhelmed in the left seat of even a simple airliner (even someone with experience in turboprops as a commercial pilot would find it a huge step). Get into the heavies and you are downright dangerous.
I remember the discussion right after 9/11. The terrorists used the sim for planning the flight but all of them were taking flight school to (supposedly) become commercial pilots.
Kind of wonder at the one who told his instructor that all he needed to learn was how to take off and fly but not to worry about teaching him to land. ???
Realistically a sim pilot would stand little chance without a lot of help in flying a jetliner. It's on the outside possibility that they could land without killing someone but that's not where my money would be bet.