It depends on what you consider small and how well you tolerate recoil. I personally don't find the recoil of full-power .357 Magnums from a medium-frame snub like my 2 1/2" S&W M66 or my brother's 2 3/4" Ruger Security Six to be unpleasant in the least and even a small frame gun isn't bad so long as it is of all steel construction like the Ruger SP101 or S&W M60, 640, or 649. While I've not shot one, I wouldn't expect the recoil of a medium or large frame lightweight revolver like the S&W 386 or 327 to be too bad either since such guns usually weigh as much or more than an all-steel small frame.
The only lightweight small frame that I've fired .357 Magnums through was my dad's .357 Ruger LCR. While not as bad as I expected, the recoil was substantial (noticeably more than full-power .44 Magnums through my 4" S&W 629) and two or three cylinders full is all I'd want in one sitting. The best analogy that I can give you is that the recoil was akin to catching a fastball without a glove.
Part of the equation for taming recoil lies in the grips. What you want is a grip with enough palmswell to distribute the force over the largest possible area of your hand without being so large as to force you to take an awkward or uncomfortable grip on the gun. Too small a grip will allow the gun to shift around in your hand and direct almost all of the impulse into the web of the hand while too large a grip will not allow you to get a sufficiently firm grasp on the gun and will direct the recoil into your thumb and fingers. While softer rubber grips cushion recoil somewhat, in my experience shape and fit is more important than material. Hogue or Uncle Mike's finger-groove grips tend to fit me well, but then again I have fairly large hands (I wear an XL sized glove) with long fingers.
Also, different people have different perceptions of recoil. I have been shooting .357 Magnum and larger caliber revolvers since I was 11 or 12 years old, so I'm accustomed to what many people would consider to be heavy recoil. What I find to be manageable or even pleasant may seem excessive to someone who is new to handgun shooting or has only ever shot lighter recoiling guns.