Yes, like some of the other posters I had a very vivid imagination as a child, was always reading and daydreaming about magical, exciting adventures. I was absolutely convinced I would be a famous film star or pop star or similar as an "ordinary" life did not seem to be an option. Anything seemed absolutely possible. Curiously I was incredibly quiet and shy, and my parents were DEFINITELY not the sort to tell me I was special, in fact quite the reverse ("you're nothing special/you're no oil painting" were common rebukes and my parents and teachers utterly despaired of my daydreaming, despite having a good brain I was no good at applying myself to anything academic or practical unless it had fired my imagination). But I was so caught up in my happy daydreams it did not occur to me that any of those things would be a hindrance.
When puberty struck it was as if my eyes were opened to the crushing reality that life was actually dull and monotonous and that I wasn't special at all, just shy, gawky and awkward and highly unlikely to ever be a princess or film star! I was fairly unhappy most of my adolescence, then in my early 20s I found I actually started to enjoy life again, discovered some (more realistic) ambition and have ended up doing OK in life - partner in a City law firm, through a lot of hard work and resilience rather than magic!
I was diagnosed with ADHD last year and suspect I also have ASD (my eldest child has both and other family members on my side show similar traits). I think this probably explains the scale of my vivid childhood imagination/daydreaming and disconnection from reality until I couldn't maintain it any longer. Once I "woke up" to reality it took me a very long time to channel my hyperfocus somewhere else positively.
I also completely agree with the posters who said that over-praising children can given them an unrealistic sense of special-ness. My sister (unlike me) was very academic, top of the class every term and parents and teachers were always telling her how great she was and how well she would do in life. She did do very well until she finished Uni, but then real life seemed to terrify her. She has ended up doing very little with her qualifications and feels disappointed with how her life turned out. I think she thought everyone would carry on rolling out the red carpet wherever she went and when it wasn't like that she couldn't cope.
I also had a boyfriend at Uni whose parents had instilled in him a belief that he was incredibly brilliant, special and could do anything he wanted. He would get furious when things did not work out that way. He did an English degree and was incensed to get a 2.2. Apparently it wasn't his fault that he "didn't like reading" (errrrmm....) and the exam board should have awarded his degree on his capability not a "stupid arbitrary exam result". I still hear about him through a mutual friend sometimes and he has not changed much but has managed to marry a rich woman who keeps him in the manner to which he feels he deserves!