I think this fits Cloud post FFVII and just before AC, before he meets Aerith again. It's actually the image song for Fatal Frame 3, in which the main character is searching for the ghost of her fiance who died in a car accident. Because the accident was due to her reckless driving, she blames herself for his death, and when she sees his ghost in her dreams, even though she knows that if you follow the dead you can't come back, she still goes after him because she still has things she wants to say to him, and she misses him.

Koe (Voice)

If you were living in the depths of the ocean
I would become a fish just to be with you
I would descend the deepest of pits
Wander the darkness forever as a shadow
Just to be with you.

Our memories still drift vividly
I had been drowning in my own sorrow
You’re gone.
I know that, I know that

The sun rises, rises, purifies my world
The warm, warm wind takes away
the tattoo carved into my mind.

If it would bring these words to you
Then I would gladly sacrifice my voice

A vivid scar and this despair
your warmth that overwhelms all my sadness.
I yearned for it, yearned for it
Even if it is just an illusion

The fading, fading warmth takes me away
I want to fall asleep in your forgiving embrace

The sun rises and rises
purifies my world
I want to fall asleep in your forgiving embrace

The fading, fading warmth takes me away
The warm, warm wind takes away
the tattoo carved into my mind.

Memories are wearing thin with time
I'm like an earring without its needle
I forget it it all fades
Your voice vanishes amidst noise of the crowd

It falls apart, I lose my grip
I'm like an earring without its needle
I forget, without a trace,
Your voice becomes static.