It's basically like a traction tire in a jar. It's not the easiest stuff to work with, but I've had some mixed success with it in the past.
There's a trade-off for sure, and Bullfrog Snot is really a Band-Aid on a problem, be it gradient, curvature, train length, or pulling power. Now that we're entering an era when even N scale trains may be able to fit current-keepers, this may be less of a problem. But for now, the fleet of N that I have needs all the electric pickup it can get!
Some guys love it, some hate it, and my thought is that if you think you need it, might as well give it a shot (assuming cost isn't a factor for you). It does come off easily enough if you decide it isn't what you need.