Well, a .357 can be pretty dramatic to shoot, but is certainly better than the bigger bores if shot out of a similarly size gun. The lighter the gun and the shorter the barrel, the more drama you will get, so you might want to take that into account when choosing.
In my opinion, for range and hunting, you want a 6-8 inch barrel (and also the mildest and most accurate shooting). For home defense and range, a 4-6" barrel. For concealed carry, a 2-3" barrel.
As far as whether to get a .357 at all, I wouldn't worry about that too much - the beauty of a revolver is that they work well over a wide range of cartridge power, and, you get dual chambering ability in the .357 - both .38 Special and .357 Magnum. In factory ammo, you can get real mild target .38 Specials to shoot that have about 160 ft-lb of energy, through .38+P, past .357 "tactical" rounds, then .357 standard, up to .357 max loads that are over 700 ft-lb energy.
Hearing damage is not an issue with proper hearing protection, and with a good sized gun like a 4-inch GP100 or S&W 686, you can shoot even heavy .357 loads without pain - the gun will jump pretty good, but it won't hurt.