How the hell do you perceive it as something good and enjoyable instead of a valid reason to get a panic attack?
Anyway, I'm guessing the answer to your question is: control. You know that you can at any moment tilt your head forward and lose the vertigo sensation. So you are safe and in control and you also feel safe and in control. That makes the experience enjoyable (I assume).