Don't shoot it without ear plugs, I know of a fellow that was hunting with one and ruptured his ear drum shooting next to a tree. They have a crack like a 357 on steroids.
Actually I prefer a Ruger 480 or the 475 Linebough to the 454 or 460. They get the job done just as well and they punch a bigger hole with less noise so I can at least hunt without ear protection. The 480's are more of a boom like a 44 but the 454 and 460 are a deafening crack.
I've had SRH's, Raging Bulls in all the big calibers, I've had S&W performance center 460 and 500 and I actually prefer to hunt with a Super Redhawk 480.
A friend of mine had a Freedom Arms 454. It was an awesome gun but I actually liked the Ruger just as well or better.
The advantage the 454 does have is you can even shoot your cowboy 45's in the same gun to just play around and have fun with the Super Redhawk.
One nice way to tame the 454 is shoot them in the 460 performance center, now that makes a nice package. The 460 with a full house round is like a stick of dynamite going off in your hand, it's really no fun to shoot and just overkill for a handgun.