Should folks building small numbers of circuit boards use surface-mount parts, or should they stick with through-hole components that are so much easier to handle and solder (not to mention see)?

Above is a video detailing one method for populating a two sided surface mount PCB. We covered using a stencil to apply solder paste for a PCB a few weeks ago. In the comments there was a debate about ...