Agreed. Fiction where the solution was "and then he found out he was the chosen one so magic happened" are unsatisfying.
There is a book I love: Lord of Light by Roger Zelazny, in which he first wrote about fantasy figures with magic powers in Buddhism tales, and then revealed that they were just humans with high tech and play gods to those who don't.