Think I've mentioned this before, but my fantasy tank #1 wouldn't be a fish tank. I want a mini-environment tank. Too long to explain what it is here, but in essence you have a mini sea bed, beach, ground, hills and mountains in a sealed tank, which eventually exhibits real world conditions - ie: little rain clouds form etc...
Fantasy tank 2 would be a pressurized tank to keep deep sea fish/inverts in.