I enjoy cooking on the bbq and am into the long slow smokey experience. You can spend a fortune on a bbq that does most of the work but I have stuck with my webber kettle for years. It can do the 10 hour slow cook with lots of smoke easily enough, you just set it up on a half and half basis, direct and indirect. Keeping the temperature right is a bit of hassle, but if you get a charcoal starter that works well. I use big lumps of fruitwood for the smoke - apple wood is good. Just lodge it in the coals and let it smoke. A lot of the flavour comes from the spice rub as well and plenty of smoked paprika goes into that.
I do have a small smoker box as well for wood chips. I use it when doing quick bbq things like fish or steaks. Because they are wood chips they burn out quickly. You get a hint of smoke which is nice. If you want a big smoke flavour you need a long cook time which creates a smokey crust around the meat.
Grillstock is a cracking BBQ recipe book which also tells you how best to setup a bbq for lots of different types of cooking.