Well just as you did with this image you could do the fog in post. There are even the MR volume shaders. Care to show what results you got with the spotlight?