We have an apple orchard close to use, so I like to grab wood from there to use. I'm really happy with the smoke I get from it, but I would love to get some post oak one of these days to try.
I some times use Hickory, pecan, or cherry, but I find myself going back to the apple orchard stuff. I actually have some grapevines I plan on trying just haven't gotten around to it yet.