Rabid DIYers think advisors can't add any value. Some advisors think everybody needs one. The truth lies somewhere in the middle.