Are these actually any good for using fogs as fogs, or are they purely aesthetic to match the HID lights?

No use at all in the fog, just for show ;)

But I wouldn't recommend them, I have some but they just don't work and I've tried everything :shrug:
 
got some of these LED's... will be fitting at weekend ... or at least trying going by this thread! :|