Getting a financial adviser could be the best investment you make, but who really needs one and do they add any value?