I always kind of liked the diagram here:
http://www.victoria-adventure....
Note the Nelumbo (Lotus) and Nymphoides in boxes on the right (not in the image), as well.
Between these is pretty much everything that might be called a water lily. I don't think I have any rights to most of these genera in the database, though.