This has long made me curious, as I have always scared of heights but I never doubted that I was a pilot. In my jobs I have known hundreds of pilots of all different backgrounds, and I have asked a fair few about fear of heights. I would estimate that 90% or more happily agreed that they had some fear of heights, mostly the similar level to mine (I hate edges unless there is a good barrier, hate even watching other people stand near them).
You seem to be going in the direction I would recommend, challenging yourself. I loved climbing and abseiling; there were times in each which terrified me, but I carried on and had my fear under control. I think had I avoided doing that I would now be much more restricted by the fear, maybe avoiding ladders (which I dislike).
How about either doing some aerobatics and spinning (you have to be high for spins, and the worst has happened!), or even go abseiling to challenge your fear in another environment?
Yawningdog
That probably makes you a damned good club pilot!