I don't think it has ever been accomplished. At least not like your pic and from that angle.
FS9, if I recall correctly, creates the low vis situation with the stratus clouds.
In the early days of FS9, there was quite a discusiion on whether to turn the "fog" on or off....and, which looks more realistic? I think it concluded with "the eye of the beholder".
With that being said, whether the fog is on or off, FS9 will render fog/haze if two conditions are met: No clouds in the metar and a low visibility setting.
As you noted, some have attempted the colorization of cloud sets (cumulus and cirrus), some the sky textures, and some both. If set up correctly, the illusion can "almost" be perceived when looking straight out at the horizon and only at that angle. At least that is my perception/observation.
I have wondered, if FS9 really does use the low vis setting plus the stratus clouds, then could a colorized version of stratus be activated with say a batch file? Perhaps a bluish set for that light-industrial view and maybe a brown mud version for that eye-burning, lung-choking, LA type of atmosphere? I don't know.