Welcome to the forum and thanks for asking our advice.
Weight is helpful at reducing pain from recoil.
Weight is a pain when it comes to carrying.
Carrying is made a LOT easier if you use a decent holster. A shoulder holster almost completely negates the weight factor on medium weight guns.
The Ruger SP101 in 327 Magnum is said to be more comfortable to shoot than the same gun in 357 Magnum. But I would opt for a Ruger Security Six/Speed Six or Service Six.
I own SP101s, Security Sixes and GP100s. The SP101 in 357 is brutal, with the lighter weight and smaller grips. The Security Six is much more manageable, especially if you install aftermarket grips (target grips or rubber grips like Hogue or Pachmayr, etc). The GP100, with its greater weight is a little more comfortable to shoot. But here is my of-the-cuff rating of (dis)comfort levels, SP pain rating is 80. Sec.Six rating is 50, GP rating is 45.
Carrying comfort levels in a belt holster are SP 80, Sec.Six is 70, GP is 50 and in a shoulder holster, SP 90, Sec Six 85, GP 80.
Sorry that I don't have ratings (opinions, all, of course) for other makes (Smiths, Colts or Taurus, etc.)
If you like Smiths only, consider an L-Frame or K-Frame paired with a really good holster. Easier to shoot than a J-frame and a good holster can work wonders.
Lost Sheep