I've been wondering lately: When is the right time or what are the right circumstances to choose to seek out a human advisor especially with regard to tax efficiency, offshore banking, etc.?
I spoke to one advisor (a friend) who manages HNWIs; he suggested a net worth of $100k-250k is when it starts to make sense. I'm still curious to find a general answer.
I would even argue that many of the cases you listed are better suited for a lawyer. Another example of a typical relationship where I pay them $X for their service instead of X% of my assets in perpetuity.
Financial literacy is a pretty basic combination of Grade 5 math and common sense. If you can't grasp it yourself with a tiny bit of effort, no structured learning environment is going to help you.