The last one sounds sick to disgusting. The others are okay.
Especially the second one is nothing special. Quite the contrary: A computer should not disobey (but those fancy pocket computers do it nonstop), even on destructive commands, but an intense warning demanding a conscious input is a good idea, albeit a luxury in Linux operating systems.
Most destructive commands will be simply executed without any further inquiry.
rm -rf, shred (including on block devices), dd, partitioning tools, mkfs will wreck havoc beyond any hope for restore, no questions asked.
