I am not scared of heights, not one bit. I like most are fearful of an uncontrolled fall.
I'm the complete opposite. When I'm on a ladder hanging Christmas lights, even 10-15 feet up, I'm shaking like a leaf. Hands sweating profusely. On the roof, my heart is pounding.
That being said, I had no issues whatsoever dangling my feet out of a C-172 at 13,000 feet. There was no sensation of height from that high up, just wind and noise. I was always nervous, but in a completely different way than being on a ladder or up on a roof. Once I was in freefall, the exhilaration of that overtook any nervousness I ever had.
I really want to restart that career, I ended it way too soon. The wife isnt a fan of some of my high altitude hobbies...