What is too big of current that will fry the voltage regulator?

IE, the tiny smt parts like the SOT-223 [the usual part found on an Arduino bd] are
rated at 15 degC/watt temperature rise, while the robust TO-220 parts are
3 degC/watt.

Those figures assume infinitely large heatsinks.

Reality is quite different.