Most of my childhood fantasies were unrealistic. They were far too exotic and exciting for me to take them seriously. I pretty much wanted to be a character in a novel. Most of my fantasies now are the same way. And yes, I am disappointed with reality.
Reoccurring ideas in these was being a bit nomadic, definitely a bum/"artist" as a cover (no career fantasies for me), perhaps something really extremely religious, and if I could have amazing clothes too, then I'd be set. I DO have great clothes & I manage some level of fanaticism in whatever interests me. Not quite a character yet. Missing the romantic subplot, genuinely tragic element, and talent/charm or whatever it is that makes people interesting.
But it's not so much where I'm at now as what I haven't done and what I fear I may never be able to do. And none these things are very specific, because I've met specific goals & they weren't what I'd thought they'd be. It's more like, "don't get stuck in something boring, typical, and repetitive". But having to work a 9-5 tends to shoot that idea down.