And Kancheepuram,Tamil Nadu is called the City of temples. And Kumbakonam. But the city that had over one thousand temples is, Bhubaneswar/Cuttack. Most of the temples have been demolished by the Mughals. What remains is only a miniscule.
This type of worship is called Saguna Upasna, Worship of Reality with Attributes. Lord Krishna explains to Arjuna that He(Krishna) appears and grants the wishes of His Devotees in the Name and Form He is addressed
There is a temple near Kumbakonam,Tamil Nadu for relief from poisonous bites and life threatening fever.
I have written on colour changing Siva in Virupaksha temple, Karnataka and another one in Tamil Nadu. I will be writing on one such temple near Chennai. Now there is a Shiva Temple near Myladuthurai,Tamil Nadu.
There is nothing called Paranormal in Hinduism. Everything in the Universe is Natural. When we come across things which we do not see in our daily Life,we tend to call them as Miracles. Fact is that we are perceiving them anew. That's all.