For me it was in the north of Sardinia, and nothing has been close to that since. The water was so transparent I could see the sand perfectly; I even caught a shrimp with a sandwich box.
During my honeymoon, my wife and I visited Stingray City and went snorkeling at the nearby barrier reef off Grand Cayman Island. The water was nearly as clear as glass and the whole experience was fantastic.