Gary Moore was a monster on guitar. Amazing feel.
As to bbb's post, in the electric guitar world, Brazilian (or other) rosewoods for that matter are usually used on the fretboard. Examples would be 1958 and up Strats, Les Pauls... A couple exceptions would be a unique solid Brazilian rosewood neck made for a 50's Cal-Mex guitarist, and the all-rosewood Telecaster that George Harrison played.
I once owned a guitar made with a 70's Mighty Mite body and Schecter neck, all solid East Indian Rosewood (that I sold to someone in the UK). As one would expect, the sustain is stupid unreal. The downside is that, in my opinion, the guitar had so much mass that the string's vibrations were not "affected" by the woods, so to speak, and the sound was a bit "metallic". On a Les Paul, the top wood is maple, over Honduras mahogany. I'm not a fan of all-mahogany electrics as they can sound too dark, but the maple cap on the Les Paul adds some brightness (as well as beauty.) And as they only made a couple hundred sunburst LP's between '58 and '60, they're stupid ridiculously expensive.
Martin predominantly used ebony for fretboards, but have moved to Richlite (a phenolic) for many of their current guitars.
How does this relate to pool cues? My guess is that for someone who is fast, maybe plays a lot of 9-ball, has a pretty firm stroke, more deliberate in their shot-making, gets to the next shot before the OB falls in the pocket, he/she would find they like maple or play better with maple, for the handles. And I would also guess that one who maybe more feel-oriented, plays at a slower pace, moves the ball around less, has more short finesse shots, may prefer or perform better butt made of tropical hardwoods. And maybe a combination of both types of woods lead to a good all-around cue. The balance and feel adjusted by how far from the joint the splice starts, for example....