As has been stated about a blue-billion times, FA strongly discourages use of the shorter cases because FA cylinders are TIGHT. Consequently powder residue, lead, copper and such can build up in front of the shorter cartridge thereby possibly impeding chambering and increasing pressures when the standard longer cartridge is used. At least theoretically, powder burn ringing or marking could also occur in front of the shorter cartridge's mouth. As even the standard length cartridges like a .357 Magnum are shot in the FA, they can become a bit more difficult to seat, due to the little bit of carbon build up, etc. in the tight FA chambers.
In my view, fear of pressure problems is most important with cartridges like the .454, .475L, and .500WE. However, I continue to be amazed at the number of people who don't know how to, or simply don't want to, clean their guns. They are the really prime candidates for chambering and pressure problems. A person who knows what a really clean gun is, and cleans his accordingly, MIGHT not have a problem, depending upon the caliber, etc.
In the case of the .41 Special, I personally would probably prefer another cylinder, if I ever thought I wanted to shoot .41 Magnums, too. The .41 Special would be a nice cartidge in the 97.