SM64's water is, well, dated. It doesn't look that good. SMS's water is fantastic, with the tropical Beach's of Gelato Beach and Sirena Beach, and the reflecting water of Bianco Hills.
SMG has pretty good water. The shallow water looks quite good, but beach Bowl's water is pretty strange, how it looks blue from far away, but turns clear when you're near it. SMG2's Starshine Beach Galaxy doesn't have that great water, I thought. It looked pretty bland and unappealing.
SM3DL's water was nothing special. But SM3DW's was quite good. Still not my ideal water (which would be something like Sunshine's, but in HD), but pretty good.
SMG has pretty good water. The shallow water looks quite good, but beach Bowl's water is pretty strange, how it looks blue from far away, but turns clear when you're near it. SMG2's Starshine Beach Galaxy doesn't have that great water, I thought. It looked pretty bland and unappealing.
SM3DL's water was nothing special. But SM3DW's was quite good. Still not my ideal water (which would be something like Sunshine's, but in HD), but pretty good.