The quality of the airports isn’t at the top with the big players, but also isn’t at the bottom. Somewhere in the middle and better than stock. The newer ones keep getting better and better.
The only option I know is the HPG H145 Action Pack. They have a scenario editor where you can place a fire anywhere you want and then you can pickup water and drop it onto the fire. It’s fun but limited to their helicopter. I’d love to do that with a fixed wing aircraft.
You can also install this and find in the SDK (Simobjects) smokes and fires that you can ajust (put them back on ground since they are made for chimney) to put fire where you want: We Love VFR - Region 1 for Microsoft Flight Simulator | MSFS
Shame it is not implemented, or at least visibility in the metar. Like rhodos (or other greek islands) are so sunny in the sim, while forest fire clouds block a lot of the sun and visibility isnt good