That was kinda the point, Cloud does kinda suck, but he eventually overcomes all that in FFVII. Zack is pretty badass, Crisis Core just confirms that.
Zack is my favorite character but they won't way too far
Well, he's a Shinra grunt. They are pretty lame and, like, the Stormtrooper of FF7.
I do agree that the game play the "Awesome Zack" narrative a bit much, perhaps in part to segue cleanly into the whole "living legacy" thing, which I dislike.
I think it might be the comparison to Zack that bothers me honestly. They tipped the scales too much where Cloud can't even seem to do basic shit right (except for the Nibelheim thing, but then that was already in VII) and Zack is a superhuman badass from Planet Awesome