Definitely overkill for most people.
You have to have a giant paw to really handle it well, and I would never buy something like that, I prefer the much smaller .45.
But the S&W 500 is still an amazing weapon, we're talking 2,600 ft. lb. of muzzle energy from a handgun, and that is incredible! The night flash and recoil alone would stun most people...