Chicago Terrain Factory has an excellent write-up of some of the non-40K terrain and tables at this year's Adepticon. Tons of other great stuff there as well; check it out: Chicago Terrain Factory.
I love the Pirate City and Warmachine City tables. There's just something about a table with a large water feature that I love. What was your favorite?
