The only exception to shooting being worse than stabbing is the RoboCop uncut edition where they mame him up close with shut guns.
On a side note, watching that Robocop scene as a kid without any sense of mortality or much of real life, I barely flinched. On subsequent rewatches in adult life, it's an increasingly harder and harder scene to watch.