Howdy KKers!
I love the whole concept of discussing what woods we use for smoking our cooks. To that end, below are a couple of links that detail various woods, their flavor profiles, appropriate use for various cooks, etc.
Dee Jay's Smoke Pit
Virtual Weber Bullet
Amazing Ribs has a pretty good discussion of the Zen of Smoke.
I hope this helps one and all!