About ten years ago, I worked for a mutual fund and insurance company and I met many, many financial advisers. Most of them care about nothing but the sale. The vaunted employee training programs they attend are generally cheer leading sessions for favored products, and any monkey with half a brain can pass the FINRA Series 6, 63, and 7 exams that allow you to sell most retail investment products.
There are some advisors (generally older and FI) who have seen investment trends come and go and have survived. They ignore company hype and focus on educating and holding the hands of their clients. They are typically not geniuses, but if you don't have the talent, time or the inclination to manage your own money (very few like that on this board, I'd imagine, but such people do exist) they can be a good option.
One other note --- while I didn't work with the whole life products we sold, the general feeling within the company I worked was that they were a scam. The products were fairly complicated, which allowed several layers of fees to be charged without much investor push back. Needless to say, whole life was pretty popular among the advisers.