Just saw this today. Add me to those shocked and saddened by this. When I first saw the headline, I too expected it to be from a heart attack or some other physical ailment, but not this.
I haven't seen any of Tony Scott's movies all the way through, but the parts I saw I liked. While they may have been silly/over-the-top, they did have a certain "heart" to them.