Depending on the type of engine, it may or may NOT be driveable after it overheats. If it's an aluminum block engine, it may well be toast. My mom killed a jeep engine that way -- it blew a radiator hose in heavy traffic on the freeway and by the time she pulled over, the engine was seized.
On the other hand, I had an old 78 Thunderbird with a 486 in it ... honking big piece of iron. Almost the exact same thing happened with it, and it was just fine. And I drove it OFF the freeway and a mile to a safe parking place because there was road construction and no place to pull over safely on the freeway. (That sucker used almost as much oil as it did gas, but that was true even before it blew the radiator hose.)
BTW, if you want a really mystifying problem, it's possible for a battery to short out internally. Then the car won't stop, and has no power, but you can't jump it either. The solution to getting it started is to unhook the battery and attach the jumper cables directly to the battery cables. Once you have the car started, you can remove the jumper cables. (You don't need a battery hooked up to run most cars, as long as the alternator's in good shape.)
Another way to disable a car, come to think of it, is an alternator that's gone bad. The alternator powers the car (including the spark that ignites the gas in a gas engine) -- the battery's normally just for starting the car. However, if the alternator goes, then the car runs off battery power until the battery goes dead. And while the battery is dying, all the lights get progressively dimmer and, if the alternator is giving out SOME power, they flicker and dim depending on how fast you're going.
I've had this happen on a remote country road -- and I managed to limp the last five miles into town by using a "jumper box" battery macgyver'd into place, and by turning off all the lights, the air conditioning, etc. (You know those battery packs you charge and keep in your trunk in case you have a dead battery and nobody to give you a jump? One of those, wired in place of the drawn-down battery.)