A cycler displays a model and switches between the models animations when you shoot it. When you press the use key on it, it will pause the animation.
A cycler_sprite is meant to do the same for sprites. It can also display models but I found my Hammer crashing when I tried to do so.
After all, they differ only little.