Cosmo Canyon when you're uncovering the truth about Seto, you fight spectral archers and they stone your party, the boss also has helpers that use stone arrows as I recall.
as for AC's flaws, I could deal with the loopy story, I mean it's obvious they aimed for pure action with this one, But they failed to make it coherent. One example is that Cloud is supposedly stronger after his epiphany with vincent due to his being absolved of his guilt. But there is never really a point in the film where is there is definitive proof of more power. One way of doing this would have been to have one of the Seph clones floor him with a specific attack, and draw blood in a early scene, and later to have the same seph clone perform the same attack, only to have it defeated by sheer skill and power. Sadly, this never happens. In the motorcycle chase there is just flailing, leaping, and inexplicable flying, Sure it LOOKS stylish, but part of attacking stylishly is functionality, you have to be able to actually do something effective with that style or it just looks stupid.
I also mentioned before, does Nomura expect us to buy that Tifa being to turn in mid air in a split second and leap off a wall she was thrown towards, yet not be able to dodge Loz's attack despite him pausing to snicker for a few seconds (which is at least two more seconds then it took for her to do that mid-air turn) is good storytelling?
Clouds inexplicable burst of strength after Sepiroth maimed him is just the icing on the cake to the stupidity. "The whole "I want to take away what is most important to you" line would have been more effective and chilling if they had kept cloud maimed, his swordsman days over. And had the rest of the party act and fight on clouds behalf. Thus showing that Sephiroth CAN'T take away what is most important to cloud, because what is most important to him, his remaining loved ones in this world, refuse to be taken away or let cloud be taken away from them. Thus laying somewhat of a mind funk on sephiroth, who has never really known love his entire life, and shaking him enough that the party, CAN defeat him.
Then there was geostigma. Why? What? HUH? Was there even a point? In the scheme of things, did the plight of geostigma really play out or mean a thing in the overall story? It just felt so tacked on.
Lastly, Aerieth. AC's defininition of Deus Ex Machina. Having her show up and council cloud was contrived, having her throw him the final distance through the omega flare was silly, having her resurrect him was stupid, and having her show up at the end in full physical form, interacting with the physical world around her along with Zack was just plain awful. Leave her be, she's dead. Arrrgghhh.
But yah, I have a lot of issues With AC. I personally don't consider FFVII to be the best there ever was, is, and will be. But I do consider it a good RPG and respect it. They could have done so much better, and I have so many fond memories of the Square that was that I hope they fire Nomura someday and offer Sakaguchi a fleet of porsches if thats what it takes to put the storytelling back into Final Fantasy.