According to my current knowledge the so-called g-spot is the female counterpart to a man's prostate. (e.g. female ejaculate contains small amounts of PSA, the prostate-specific antigen)
So I obviously cannot tell you my experience but maybe there are similarities to a man's ability to have prostate orgasms.
Not every man experiences prostate play as sensual. Most men really worry of having the prostate checked or ultrasounded. Some even describe the examination as painful.
So if a man is not able to get enjoyment there is a path of 'awakening' the prostate with much, much relaxation and gentle massage. Some tantrics and other bodyworkers even say that men store trauma there and have to transform it during bodywork and then being able to experience that joy of an awakened p-spot.
I did a long run with my p-spot, with aneros, relaxation and stuff and finally managed to awaken this sensual wires (which sent me out of space during prostate ultrasound once).
Finally my experience is that this arousal and sexuality is completely different from the usual one, it's difficult to describe. If a usual orgasm is like juping up then a p-spot one is like drivin in a halfpipe.