Found an awesome Quake High Resolution project, called Darkplaces.
I made some comparison screenies.
Translucent water!
Pics don't really do it justice though, you have to see it in motion to appreciate it. There are also sound, ambience, model and some gameplay changes.
Here are...