On topic, I use maya more than anything, with a bit of photoshop on the side, and after effects for compositing. I'm also just starting to use mudbox a bit, but really need a tablet for that and I'm really not very good with it :x
This is a matte painting I did for a recent assignment, it's mostly photoshop, but the fog is a maya fluid effect. I didn't actually change it much from it's example settings, but I rendered it out in layers according to depth and then only used the alpha channel to mask a 100% white layer to re-create it in photoshop.

