For me it depends on who is the so called a advisor is! if its popular like Mcafee will it will help to influence but to those not popular i think its just a waste of money. Since investors nowadays are not the same as before they dont care about who is the advisor. they are more interested on the project profitability.
but sometimes the role of a person with a big name is also important for marketing. some projects even rely on it to attract investors into the project. inevitably, all of that really happened. but it depends on the ability of the developer, where the market will not be able to only with the support of people with big names. real development that must be done to attract incoming investment.