I have a 2x7 on my .243. I've had no trouble on prairie dogs to 300 yards with it. When doing my walking-around and sneaky-snake deer hunting, I keep the scope set on 2X.
IOW, a 3x9 should be plenty good for most shooting, and I certainly wouldn't want more than 4x14--although I've never gone that big with a scope...