Not really, it adds a few pretty lighting and textural changes but also changes Alyx in to an outrageous buxom wench and messes around with the aesthetic of the universe a bit too much for my liking.
There is however a 32-bit version that doesn't change those character models. It's pretty cool but it crashed my computer at a few places, mostly in the final third before the Citadel.