I was amazed how much of a following the 5906 has. I carried one for 2 or 3 years out of my police academy, and I liked it since it was the best of the S&Ws I could choose from at the time.
My complaint was that it was heavy. On traffic stops in my early years, I'd exit my unit, grabbing my side handle baton and a large flashlight as I did. Sometime during that stop, I'd have both of those items hanging from my belt. The pistol plus all of that and more really weighed me down, especially on foot pursuits. I eventually went to other pistols after that and to lighter/smaller equipment.
The above may seem trivial, but working part time duties where I was on my feet for many hours at a time, that 5906 weighed a ton.
The other problem was that it clanked or rattled when you shook it side to side. There was just too much play between the slide and the receiver. I sold it to another officer whose 5906 was stolen in a home burglary. I saw him a couple of years ago on a traffic stop, and I asked him about it since I was about to retire. He told me that he had sold it to a sergeant on our force, and when I later asked that sergeant, he told me that he had sold it to a family member.
I really wouldn't go out and purchase one, but I wouldn't have minded having a shadow box with my first and last duty weapons displayed in it. Other than the original one, I find no value in another 5906.