My gf had a horizontal hood piercing that she decided to abandon after about 4 months because she found the jewelry resulted in too much stimulation.
Not an option for me as I don't have an independent hood structure, rather my neocltoris is nestled between the labia majora and the inner labia really begin below my clit so there's really nothing to pierce.
She had hers done by Raelyn Gallina who (was lost to an aggressive breast cancer in 2014), I held my GF's hand as it was done and felt quite an electric shock. As long as you have enough structure to support the piercing it should go well -- it's one of the fastest healing piercings you can have done.
Good luck!