Hackman won Academy Awards for the violent 1971 drug saga 'The French Connection' and the 1992 western 'Unforgiven'