While it does no harm to be safe, water most certainly can be added to acids without problems, but not all of them. You can introduce water in any volume to tech grade nitric or HCl with no reactions to speak of.
If one observes the rule of putting acid in water, not water in acid, there's nothing more to remember, so play it safe so you don't form bad habits.
While there may be other acids that would react violently by adding water---the one that is of concern to the home refiner is sulfuric. As you alluded, the reaction is exothermic, which can turn the water to steam instantly, causing what is, for lack of a better description, a steam explosion.
Even when introducing acid to water, when it's sulfuric, it should be stirred well while introducing the acid in a small stream, to avoid localized heating.
Lou or Irons may well add their comments to this subject. I'm reporting only that which I have experienced.
Harold