As of patch 3.0.2 they removed the SetCameraPitch() API call so we can only adjust Yaw not Pitch now
So this macro / key bind relies on your mouse being centered on your death knight I'm afraid.