I was searching around for a mod like this on the Nexus but couldn't find one (there probably is one but it has an odd name or keywords or something). So I figured, what the hell, I'll just whip one up myself. This simply replaces the 256x256 cloud texture used for ambient fog and mist effects in dungeons with a 1K resolution one. There is also a teeny tiny bit of extra noise added, to sort of give the impression of visible dust and debris floating around in the air but I tried to not be too blunt about it.
It's a very subtle change, but it's the little things that count!