Falloff Sphere.

I’m looking for a fog sphere to help fake glows around lightbulbs, that will also fade off when you get closer. I tried the Falloff Sphere in the engine content but the edges around the sphere are hard and the falloff parameter doesn’t help. Can anyone help?

Cheers,
Luke