I love Final Fantasy VII. I'd never name my kid Cloud, though. Personal taste, I guess. I don't find it horrible, since it's really not that far off from other nature names like Sky(e), River, Sage, Wren, etc.
Now, the two baby boys named Sephiroth sighted by members of the other name forum I post on... THAT's another story.