A good financial advisor can be valuable indeed, but they aren't miracle workers. Here are a few things you can reasonably expect a competent financial advisor can do for you along with a few things you CAN'T reasonably expect.
Is your financial advisor a bully? I know a lot of great financial advisors but then I run into the bad apple that gives financial advisors a bad name.