As far as the pleasant smells of cut woods, I would say my faves would be :
Cherry - (mild and pleasant)
Paduak - (has a certain something that appeals, though hard to pinpoint!)
Ebony - (kind of reminds me of maple syrup)
Poplar - (smells like savings)
Snakewood (smells like burning money....)
The not-so-pleasant for me would be:
Cedar - (I actually like the smell for the most part, but it always seems to make me a bit nauseous...has the perk of being a natural mosquito repellent though)
Cocobola - It takes several instances of serious scrubbing to even get the smell of touching it off of your hands
Zebrawood - I doubt that I have to explain this one to anybody
Red Oak - I actually kind of like this smell in "small" doses, but prolonged cutting makes it seem like I have a dab of Elmers glue hanging right beneath my nose
Camphor - Sort of bracing, until you turn it on a lathe...once you do that, your whole garage/shop, yard, and surrounding neighbor's yards smell like the concentrated Vicks vapor rub that my grandma used to slather all over my chest before bed when I had the sniffles. Brings back memories of "I don't care what it smells like, it will make you feel better now go to sleep!"