there will be an improvement, but nothing to write home about.
If you want excellent night 'vision', you should check out the HID systems for the Volvo S60s. I understand Volvo makes them now, and I bet you could get some installed in your car.
And btw, some people hate it if you're running around with your fog lights on all the time.