The best of the dead definitely have to be Jennings Island, Water Lights District, and City Centre Tower. One of my personal favorites was Titan for Uptown but even though I liked the design it wasn't anything special that cant happen some other time down the road.
Things like or of similar caliber as Endeavor Parkside will come again but those projects were all very altering for their setting and the city. By the way, its a shame for some of those projects that Galveston never got to see. They've made developments like these very difficult to build on the island but do is it possible that the coastal areas of Brazoria County ever get these type of developments further (and I mean much further, like 10 or 15 years) down the road? There's no interstate access down that way but there's a lot of potential there that can spurt at any given point.