I installed Super Turbo Lighting Mod to give it a go. I think it creates some nice effects but it's definitely a little OTT in places.
Here's an example where it's too much if you ask me.
Here you can see the depth of field it adds which I'm still torn on. It's a little extreme, like the lighting effects. You can see the hut a little ways in the distance, is not really that far away but it's quite heavily blurred. And that's really all the effect is - blur. It doesn't make things look out of focus. If that makes sense.
One of the cool things the mod does (which is hard to capture in a still) is add shadowing from the clouds. I'm not sure if thats a completely new thing or again, they've just made it more extreme in the mod. Either way I'd never really noticed it before but it looks really cool with the mod one, especially when you're in a wide open space and you see it.
In general the lighting has higher contrast which does make for some dramatic skylines at dusk, but it does mean the game in general is darker - both at night and indoors, at any time of day.