Cycles normal input relative to object's rotation
Thanks to Mr Zak for the pointer, I started fiddling with the vector transform and that gave me the desired result.



This is without the vector transform:



And this is with vector transform: