The Morningstar reports can provide valuable info but I think some studies have also shown that Morningstar ratings have essentially no predictive ability for future performance.
My philosophy is that about the only thing that is guaranteed in any fund is the fees. And over the long run, actively managed plans (in general) have had a hard time overcoming their fees. Advisor-sold funds will likely have additional fees added onto that. That combined drag on performance becomes very difficult to overcome with time.
Another problem with actively managed funds is that they tend to suffer from taxable gains along the way due to frequent turnover. That is not an issue with a 529 plan, so they look better than they might outside of a tax-shelter. Or, not as bad.
To address the original question:
Personally I would use only a fee-based advisor. That at least gives you a shot at comprehensive and objective advice. An advisor that's paid by selling certain funds has no incentive to sell anything else, and even if he was extraordinarily honest, it's quite likely he doesn't even know about some other options. He has no incentive to research something that won't pay him for his time.
In my experience it's extraordinarily difficult to find a good financial advisor. I've had one who was paid by selling advise against something that was clearly a better deal for my situation. And I've had a fee-based "know it all" type completely dismiss an innovative idea that clearly made sense for me. I've also had preliminary discussions with several others who didn't know much more other than how to print out some pie charts. I've even had a well-regarded professional tax accountant screw up a tax return that was very costly to fix.
So... the way I currently look at my finances is that there is nobody more interested in my personal situation than myself, and so I've simply decided to invest the time to manage my finances myself.
And by doing it myself, I save a lot on advisor fees. So I don't have to perform as well as I theoretically might with a "perfect" advisor because I have some free money to screw up with.
All that said, if I did find an advisor that I felt was truly exceptional and whose advice I could trust without double-checking, I would retain them in an instant. The time savings alone would be considerable. But, good luck finding such a person.