As everyone else has commented, the location is extremely unique and I thought it was worth staying for that reason. I enjoyed watching boats pass through and living literally right on top of the canal. I also really enjoyed the tiny house and how well the space was designed.
The one major drawback which I don't think has been emphasized strongly enough by other comments is the noise (triple cannon-like "boom!" sounds) of the crossing 3-car trolleys which run often (every 15 minutes), even late into the early morning (2 am). The provided earplugs muffle the sound, but I still had difficulty getting restful sleep.
I don't regret staying, but don't think I'd stay again at this particular location, and thought I'd mention it for any other light sleepers where it might be a significant issue for consideration.