It has no additional flavor other than adding sweetness. I would rather have no syrup than “fake” pancake syrup (e.g. Ms Butterworths).
I much prefer maple syrup. Of course it is expensive, so the Log Cabin table syrup is a good substitute that still has actual flavor and is affordable.
Edit: Also if you still want maple flavor for cheaper, a mix of half maple and half cane works good, like the stuff at Cracker Barrel. It doesn’t deserve the hate.
One thing it’s great for is making granola that holds together. Perfect consistency and sweetness. You need to use a lot because the point is to get the oats to stick together, so it would be ridiculously expensive to use honey instead like some recipes suggest (and I think that would probably make it too sweet, since honey is sweeter).
I used agave to make granola once. It didn’t taste great because the recipe wasn’t that good, but it held together really well.