In the end all they do is give a bit of advise, only you know what you want, what your risk tolerance is etc. No matter how good a financial ad visor is, unless they know every single thing about you they can't do that great of a job.
Most people see them as someone else to thrust their responsibility for their financial well being off onto, that is the farthest thing from the truth. Only the very rich can afford to take someone else's advise without learning about what to do for themselves.
In my opinion they exist because people want someone else to tell them what to do and people don't want to think because "like you know math is hard and stuff".
I am not a big Suze Orman fan but this is the first book about finance that i read and it isn't bad.
http://www.amazon.com/The-Road-Weal...sr=8-1&keywords=suze+orman+the+road+to+wealth
At the very least it was a good start. I suggest reading a couple fairly recent books (2000 or later) on the subject.