At several HPR launches, I have seen special effect engines used. One throws a shower of sparks. One was designed for a large roiling smoke cloud. One had a long fire trail in takeoff.
Are there any for LPR that have effects like that?
No. Not any more, technically speaking. There used to be something called "FX" motors (as in "special effects" back in the 80's made by Cox IIRC, but they haven't been available for well over a decade or more. Basically all they were was delay grain (lots of smoke, no thrust) in a motor casing, designed to be installed in/under a rocket (in a second motor tube) and ignited by a second ignition system at some point before the actual launch. The FX "motor" would then produce big billowy clouds of smoke as a special effect for several seconds, and then the second launch controller with ignite the regular rocket motor in the rocket itself which would then lift in the usual manner. As far as black powder model rocket motors are concerned, that's all that's ever been available in "special effects" motors.
HPR motors are composite propellant, which is entirely different, and they can be formulated out of different chemicals to give different colors of flame (red, bright white, extremely smoky, blue, green, etc) and/or have special burn properties (Warp 9 and Blue Thunder propellants which burn very fast, down to say "Smoky Sam" propellants which burn very slow with prodigious smoke but little/no visible flame). They can also include titanium sponge (dust, basically) in the propellant grain when its cast, and when the motor burns, the titanium burns and is ejected from the nozzle as a shower of white-hot sparks (sparky motors).
While it's probably POSSIBLE to engineer BP motors with different colors or other such effects, none have ever been produced or offered for sale. Really such motors would be "fireworks" since the effects would solely be for visual purposes and serve no purpose relating to the propulsion efficiency of the motor (and usually detract from it actually). This would further blur the hard-won separation between model rocketry and fireworks, causing more difficulty in getting launch fields. It would also cause a lot of issues related to flying fields and what motors are allowed and what ones wouldn't be.
For instance, I DO NOT allow *ANY* sparky motors to be flown by the clubs flying on our farms. I don't need the additional significant risk of grass fire that they present. Fortunately, since we don't have HPR flights either, it's not much of an issue, but there *are* some sparky motors that are not *technically* HPR motors, but actually MPR. Still, just to make sure "everyone's on the same page", the standing rule is, NO sparky motors allowed whatsoever, regardless of power level, certification, etc. I can imagine the amount of confusion and problems with folks showing up with a fistful of "effects" motors in ALL power ranges, regardless of propellant formulation (either BP(black powder) or AP (ammonium perchlorate composite propellant, or APCP).
There are special requirements necessary to minimize the risk of fire when flying sparky motors, but it really depends on the vigilance of the local club and conditions as to how they're enforced...
Later! OL JR