Obviously subjective, but it's pretty easy to search this topic and find several woods recurrently mentioned. Searching more broadly for "tonewood" will provide a lot of information, as similar qualities in musical instruments are desirable to cues. There are also a number of species that could be excellent which haven't been applied much or at all to cues. The world of wood is pretty fascinating.
What surprised me most is the variability from piece to piece of the same species, which correlates to straightness, evenness, tightness of grain, and density in general, but even within that there are many outliers.
Personally, I've not made any of it into cues, but it is quite interesting to sort through a pile of spindle blanks and tap them to feel the tone and sustain. I've often found among the candidates I select visually for grain and appearance a piece that just resonates differently -- brighter in tone and particularly longer sustain. I've got a piece of olive that is just different somehow than every other piece I've seen. And a piece of BRW that seems like if you could somehow suspend it in air would resonate for minutes. I can't visually tell anything that makes those pieces different. But I've also not turned them into cues, so maybe I'm picking the wrong thing altogether.