I think the Bee Galaxy, from Mario Galaxy, showcased what I think is my perfect level design.
Not so much that is was some amazing level, but that it had the perfect formula so to say. An open, unique level with multiple things to do, nonlinear in design and almost like a self contained world...