Indeed. As an amateur astronomer and astrophotographer, I spend quite a bit of time going through various weather charts and services for my local areas. And a fair portion of the time, the weather is “close enough” in MSFS to what’s out there. Temperatures are typically pretty close. Cloud cover may not always match perfectly. Precipitation may not be totally accurate, but like you said, broad-brush, it’s similar. Sometimes it’s a night and day difference, but most times it’s reasonably similar.
However, when it comes to winds, that can have a major impact on flying. Using real world real-time reports in the sim is a crapshoot. Especially when the weather generated in the sim is based on a forecast model 12+ hours old.
They spoke about this in the last Q&A. It seems like they’re trying to use a more timely forecast model (still not real time) and to blend it with real time METAR reports from airports to generate the sim weather. And this is supposed to land in SU7. Or at least the initial steps for it. I’m sure it will take some time to work the bugs out though.