I was only 8 years old when the Watergate story broke so most of what I know about it I initially learned from the movie, All The Presidents Men.
Personally I don't think he is a hero or a traitor. I think he was instrumental in uncovering a Political Scandal. Other than that, "Thanks for playing our game".