The most feared snapping turtle in the United States is usually considered to be the alligator snapping turtle. They just look mean (and they are).
Second place is awarded to the common snapping turtle. They have the same generally bad disposition, the same ambush hunting techniques, and they are big enough to remove part of your hand if not just a few fingers. They will make short work of it too.