Hickory and fruit wood for pork - I would like to try pecan and alder eventually too.
As for mesquite I love it on big slabs of beef (prime rib, brisket,london broil), but I use it rather sparingly, just to flavor the meat. I do notice however my family don't seem to like mesquite all that much.