I have an ES .460,that's the snubby with a 2 3/4 barrel-my take is they're not
that bad,but I also say watch what load you stick in it.
I've shot 260Gr FMJ loads and I want to try some 270 odd grain stuff they have.....no way in hell I'd go over 300 in that little thing!
The other thing I'd stay far away from is the 200gr "screamers" those are meant to have high velocity from the long barrels so you can just imagine what all that powder is going to cause out of a short tube!
As far as recoil goes....I've shot full power .44 mag since I was about 14 so I'm probably the last guy you want ask about what the kick is like,but I will note that the 260 grain stuff is about at my upper limits for a handgun,it can be done but around ten shots and I need a break.
So what use is it? to be honest if you're a gun nut the only use you need is it's FUN!
but it also is good for close in "get the hell off me" for a lot of things,maybe a bit small for real big bears but beats fingernails.
And if you insist on shooting it a lot...try shoving .45 Colt into it,turns it into a .22 basically,just make sure to clean the chambers real good after,it gets messy and can make .460 shells stick.
You can use .454 but...hell it's still a beast,so you won't fire more then a few rounds.