We had 870’s with Remington folding stocks where I used to work but I found every excuse possible not to shoot them. Recoil was pretty severe.
The ones we had did not have any kind of recoil pad, just a metal plate for the butt plate. (Earlier versions had a thin piece of rubber pad - maybe ¼ inch thick - glued to the butt plate, but it tended to fall off.) Also, the hard plastic pistol grip was a little thin at top and could hit the web of your hand pretty hard if the stock wasn’t pulled firmly into your shoulder. Lastly, the metal stamping going from the receiver to the butt plate tended to be a little wider/higher than the wood stock – get a little careless and you could get whacked in the face.
If storage is an issue, they’re the way to go. But if you’re going to being shooting your 870 much (at least with slug or 00 buck), you’ll enjoy it a whole lot more with a traditional stock.
I suspect the LEO only designation is a voluntary restriction – possibly since Remington does so much business with LE outfits. I have seen these second hand at gun shows – look around hard enough and you may find one (though probably overpriced).
It is a well-made, solid feeling stock that locks up nicely. It does have somewhat sharp edges along the sheet metal.
(Incidentally, these are standard issue with the Secret Service.)