I'm really impressed by Icenhancer. Even with older video cards, it makes GTA IV look magnificent.
I've also tried CryENB and P.A.R. They're also nice, but not quite like Icenhancer.
I wonder, if there are any other mods that are as amazing as Icenhancer or even better perhaps?