Adirondack spruce is the "Holy Grail" of top tonewoods right now, mainly because of it's reputation as the wood of choice for pre-war instruments..
Sitka spruce was the choice for tops after the war by Martin.
European spruce has it's reputation from the wood of choice for Stradavarious.
Englemann spruce is also a good tonewood and is being used by several major manufacturers.
Lutz spruce is so rare that as far as I know the only people using it are Luthiers. Excellent tonewood!
And then there is redwood. Certainly a tonewood but mostly valued for its appearance.
Western red cedar is also a good tonewood. It produces good quality sound from the first note. There is some concern among luthiers that this wood may degrade in tone over the long haul where spruce sounds better over time. The jury is still out on the western red cedar.
There are certainly other top woods available and used, but these are the major ones. The thing about luthiers is that we strive to coax the best sound out of each piece of wood, no matter what kind. There are so many variations in this type of wood, even pieces from the same tree, that it would be difficult to place a hard rule on the sound achieved from any particular type; especially spruce.
Wood from the same billet may sound completely different when coupled with different back and side woods. This holds true for differing guitar shapes also.