The problem with 9 volts is that the termini are next to each other. It isn’t just a matter of metal being near it, but any metal that touches both positive and negative terminus will complete the circuit.
This could happen with any kind of battery, however since most have their connection points on opposite sides it isn’t likely.
The problem isn’t just that it heats up and uses up all its power, but it can be a fire hazzard. When I was a boyscout we were taught to keep a 9 volt and steel wool in our emergency kits because if you can’t find dry kindling you can put the steel wool under you wood and ilight it on fire with the 9 volt. I have done it on several occasions.
Always store batteries with care, but particularly 9 volts.