Do any Nvidia cards (especially the GeForce series) have on-die thermal
sensor diodes for core temperature measurement?

The 6800GT does.

Is that it? I would hope that all current and future cards incorporate
this feature. It gives great piece of mind to know that if the fan fails,
the hardware will not fry itself.