ON and OFF (and sleep?)

Interesting, macegr. I never realized that.

How would that work with the arduino variants that don't have the FTDI on-board?

You just desolder the power LED, power thru the regulated power input pin and... hack some custom code to access power saving modes? Those modes aren't supported by the standard IDE, right?