One exception - of a different kind... Flash indoors with most TTL BL flash units (like SB-700, SB-400, camera internal flash, Yongnuo TTL flashes, etc)... Any of those TTL flashes without an overt TTL BL / TTL menu themselves will be TTL BL (Nikon is a TTL BL system).
Spot metering changes their metering from TTL BL to be TTL, which is more appropriate for indoor flash. Flash never does spot metering, it has its own larger center area it always uses. But indoors (assuming the desired low ISO), the ambient light is normally low level, insignificant, we are using flash instead. Then when insignificant, there is basically no meaningful metering of the ambient light indoors, Spot or otherwise. So typically, with indoor flash, Spot metering only changes the flash out of TTL BL mode, to TTL mode, which usually usually gives a better flash level indoors.
Outdoors for fill flash in sunlight, the default TTL BL mode is about "perfect".
Yes, and one has to remember to revert the metering mode to Matrix when going shooting something else without the flash or serious exposure inconsistencies will be noticed. Don't even ask me how I know.