Right ok,

Humans dearest friend,
Always there in times of need,
In the ruins of great pride,
I here and now reside,

I've now come to the conclusion of another answer, after thinking about the original hint, as I said it was related to Cid, but the answer itself wasn't, or it could be in a way. The dreams getting bigger and bigger was one thing that struck me as nothing to do with pride, but as LN kept telling me to look deeper I found out there was another meaning to it. The dreams getting bigger and bigger refers to wants and goals growing to another standard/level.

As Cid's dreams grew, first it was the sky, (tiny bronco) then it was the rocket, then it was space. That's how his dreams grew.

The only other people who really had such a powerful aspect on dreams were shinra. They wanted mako, then they wanted the promise land, but in order to follow sephiroth they needed to look for ways of transport. The gelnika was one of the transportations, one of the shinra's pride, and also Cid's if you read the storyline correctly.

Gelnika was ruined, and sent underwater by one of the weapons. Now thinking carefully at the riddle after realising the main reason for "pride" and the hint. Humans greatest friends in this game are Summon materia's. Human wouldn't necessarily say human to another one of it's kind. When you need them you can summon them. That's why I believe that the answer may be Hades. You find it in Shinra's "pride".

:S