Or rather, by the time you read this, today!
I'm looking forward to this patch. I really liked the storyline of 5.1, and it will be interesting to see what happens in 5.2.
Since I am raiding primarily in LFR, I won't get to see the new raid until next week. Blizzard is touting it as the "new Ulduar", and that is a very high bar. It will be interesting to see what happens.
There aren't really a whole lot of changes for Holy paladins this patch. Mostly changes aimed at PvP, increasing cast time of various crowd control abilities. Hand of Purity does get a straight buff, and Eternal Flame gets a buff when you cast it on yourself.
What are you looking forward to in this patch?