So some beautiful African blackwood (ABW) is my favorite for the front to match a cf shaft. I love it due to many reasons one ot them... it has some character and grain in it. The only problem is that more than 50 years old ABW I have is heavy like hell (something like 1340 kg/m3) and in that quality it is harder and harder to get.
Of course there are so many other beautiful dark woods to choose from. From what I have and worked with... my second favorite would be dark amazon rosewood...but I'm quite new in cue-building.
When it comes to the wood for the handle the choice is so wide ... again if talking about look only it is very much a matter of preference and what you like.
I love ABW & Pau Rosa combo and not only for the look but mostly for their contribution to the hit...
Among some my future projects I have two plain janes: 1. ABW forearm & buttsleeve and Pau Rosa segmented handle; 2. Dark amazon rosewood forearm & buttsleeve and olivewood burl stabilized both with some nice rings and both in my mind yet).
For those not in the metric system mode that wood is 83 lbs per square foot. A straight tapered cue butt 29 inches long .850" at the joint and 1.250" at the butt has a wood volume of 25.4 cubic inches and would weigh 19 3/4 ounces made solid of this wood. Add a pin, finish and shaft and you will have a 25 ounce cue.
So if our goal is say 15 ounces for the finished cue blank to add a pin, finish and shaft to the cue will be bit over 20 oz. which may be perfect depending on the cue. Want 19 finished weight for the entire cue with a metal large pin? Better shoot for 14 oz butt at finished size.
What wood weight does this translate to? About 58 lbs per square foot average butt weight for the wood for a 19 0z cue. . Good solid maple is about 52. Purple heart around 55. And there is a ton of wood in use commonly well under what I consider a baseline of 58 lbs/square ft. Any time you see a cue built out of woods lighter than this you can be sure there is metal weight lurking somewhere inside to make it up to an acceptable weight. Where and how much is added will greatly change the hit of two identical weight and wood combination cues. It can be at the a joint, behind the pin at the joint or in the butt in the case of most production cues with changeable butt weight screws. This is because most of these cues are made out of wood that's too light to create a playable cue by themselves without some help from metal. Water is 62 Lbs btw and any wood heavier than this will not float.
So when I build full core cues I don't have the option of weight at the A joint but I can tweak things other more subtle ways with core weight and size, and of course wood selection.
My ideal cue construction is a purple heart core with a lighter weight handle in the 52-53 range and a heavier forearm wood in the 65-70 range with that also at the butt sleeve. Makes a nice forward balance cue in the finished weight range I like.
To address the OP question you should be thinking about the density of the wood, not the color. And work backward from there.