3rd Generation autos (like the 5906 you are looking at), their Sigma line and their newer TSW and "Value Line" series autos simply work. I've heard some bad experiences with the old S&W autos, but those days are long gone.
I've owned two 5906's, one newer one with an adjustable sight and rounded trigger guard, and an older, fixed sighted, square trigger guarded version. Both were completely reliable with any FMJ, JHP and mostly cast bullet reloads that I shot in them.
I would still own them both today if I didn't move on to mostly DAO S&W's. Also, the 5906 is a HEAVY pistol. I found a like new 5943 (same size, aluminum frame, DAO) and liked that one better. But, the 5906 is like shooting a .22 with the low recoil of the 9mm and the weight of the pistol.
Out of all the S&W autos I've owned, 2-5906's, 2-3913's, 2-6906's, 3954, 3953, 2-645's, 2-4506's, 457, SW40F, SW40V, SW40VE, SW40G, 2-SW9F's, SW9VE and SW9GVE, I've had exactly ONE malfunction, and that was in the 1st Generation SW40F that I had over 8000 trouble free rounds through. One of my 645's stopped ejecting one time, but it was a broken extractor. S&W fixed it for free, and it's been trouble free since.