Like other mythical monsters in folklore and entertainment (such as the revenant), the truth lacks the horror created by the fiction writers.
I’ve never seen a gargoyle, except in pictures and videos. That’s simply because I’ve never lived in areas with old architecture. I’ve seen water spouts as nothing more than water spouts. I appreciate the people who design gargoyles because it means they have imagination. A non-gargoyle water spout is boring.
I suppose a gargoyle is practically useless in places where it doesn’t rain a lot, like most of the state of Arizona. It’s probably also just as useless in places where the rain can’t be kept away from the building because of wind, like in the tropics.
The monster may have originated with a French legend dating back to medieval times. I was introduced to the notion with a 1972 TV movie called “Gargoyles”.
My family enjoyed the animated TV series of the same name that aired from 1994 to 1997. I didn’t because I was never home when it aired.
If you’re fascinated with fictitious monsters, you can probably find enough related material to entertain you for hours. Here are several references I’ve dug up:
I’m surprised I’ve found so little compared to other monsters in entertainment. Zombies seem to be the favorite these days, but it used to be vampires and werewolves. Gargoyles are way down at the bottom of the fiction list, below mummies.