The "frustrated revelation" is a common dream motif. One of the most famous instances of it was dreamt by the film director Alfred Hitchcock.
Somebody told him that his unconscious could be a great source of inspirartion, if he could remember his dreams. So, he put a pencil and paper on the
nightstand beside his bed. Sure enough, a short time later he wakes up in the middle of the night with the greatest story idea ever. He scribbles it
on the paper, and falls back asleep.
When he wakes up the next morning, he remembers the dream, but has forgotten the story idea. He turns to the paper in anticipation. And there he
Boy meets girl.
Is that the unconscious jerking Hitchcock around?
Maybe. And yet, Hitchcock made hugely successful psychological movies, mostly "suspense," that is, manipulating his audiences' heads in real
So, I think Hitchcock's unconscious delivered. It was already delivering, in fact, before the dream, but delivery occurred when he was wide awake,
not when he was dreaming.
Maybe the message was that his unconscious works best on conscious concerns when consciousness is there to work with it. Maybe dreamtime is best spent
on other things, which aren't conscious concerns (and maybe should be).
Food for thought. Freud (unconsciously) borrowed "word association" from an essay he read when he was an adolescent,
It's not that long, but the last paragraph is the money part:
"And now, here is the practical application I promised you: Take a stack of paper and write. Write everything that goes through your mind for three
consecutive days with neither hesitation nor hypocrisy. Write down what you think of yourself, what you think of your wife, what you think of the war
with the Turks, what you think of Goethe, of Fonk’s trial, of the Last Judgment, of your superiors. At the end of the three days you will scarce be
able to believe what new, unheard-of thoughts have come to you. And that, my friends, is how to become an original writer in just three days!"
If you're a musician, then I'll bet music has the "association structure" for you that language has for a writer. So, my guess would be to adapt
that advice to your context, and see what comes out.
No guarantees, but that's a way that has worked for others for a long time who wanted to tap unconscious creative juice in service of a consciously
adopted goal. Good luck with it.