I'm posting this in the hopes this might help someone else.
For a long while (years, actually), I used to occasionally have the same two dreams that would manifest themselves in different ways.
In one of them, I would go diving off a springboard, knowing in my heart I was very good at it, and yet, every time I would dive, I would end up in very shallow waters, mud even, and whatever euphoria I had felt, would go splat in an instant.
In other dreams, I knew I had the ability to fly, yet every time I would actually do it, I would barely get my feet off the ground. It was a pretty pathetic sight to see, just kind of hovering like 1 foot off the ground, how sad is that? Might as well walk, right?
After these dreams started to occur quite often, with some variations, in a matter of several months, I started praying about their meaning, because it just kept nagging at me.
Eventually, God let me know that I had these dreams because I thought I needed special giftings to accomplish anything significant and feel good about myself. He set my head straight and let me know that He already loved and accepted me, and that I did have giftings, but that the accomplishments due to them would be God's problem, since my gifts are of Him to begin with. After the lights came on in my head, and I agreed to see myself as God sees me, and I repented, the dreams never happened again.