I've hit 10 or 12 patches before either a blowout (tear too big to patch), a valve stem leak (impossible to patch), or some other unpatchable situation caused me to toss the tube.
Really, if you patch it correctly, you're no more (or less) likely to have another flat than you are with a new tube.