With the combination of a professional P3D license, weather add-ons, and quality add-on aircraft from companies like PMDG, you really can recreate a lot of those scenarios with exceptional detail. Throw in a high-end VR headset and you can really feel like you are there! Here's an example of me playing around at home ignoring a windshear alert:
Similarly, I enjoyed a mission that required landing a 747 in Singapore during a monsoon. I'm really looking forward to FS2020 and what it'll look like to do the same thing with the graphics enhancements and new weather simulations.
"Successfully take off in this helicopter in adverse weather/terrain conditions"
The "too soon" bit gets to me... maybe that's how some people cope.
If the mission/scenario scripting engine is capable enough, there would probably be lots of scope to build famous (and fictional) failure scenarios.