Had a map that encircled a lake. The plan was to drain it, build a glass fort in it, then refill it. To help refill it, I built I giant reservoir. It was about 30x20 and 5 z levels tall.
Problem one was I built it too soon. There was an aquifer, and since the surrounding area was heavy forest, I built it out of wood. But the map had no magma and I ran out of wood making clear glass blocks. The caravans weren't bringing wood either, I think it was because they didn't count the logs as being used and thought I had plenty in stock. So I had to tear it down.
Problem two was I filled it too soon. I had attached a side room with a bridge to the bottom. I was going to breach the wall and between the bridge and reservoir and drain it by atom smashing the water. Now, I knew about water pressure, so I built a roof over the room and a series of doors to act as an airlock. What I forgot to do was to go back and put a roof over the doors. When the wall was removed... well, it was basically a giant, blue explosion that covered the screen in less than a second.
The real face palm moment though, was if I had the bridge raised at the time, the water would have gone though a diagonal and lost its pressure.