It depends on how it is utilized but more often than not relying on dream logic will drop you into deus ex machina, which is just lazy writing. It worked well in link's awakening because,
it wasn't link's dream, it was the windfish's. Koholint was a real place it simply existed, in essence, within the god-head's mind. It left you feeling a twinge of regret waking the fish, because the land and all the relationships and bonds you created during the adventure would cease to be, yet at the same time produced a sense of closure because you know that somewhere and in some way they are still there. If in the end the whole thing wound up being link's fever dream I would have taken a hammer to the cartridge because it would have made the entire experience a cop out.
Mario 2 is another example, but the way they got mario and gang into that game at all was via dream logic so I suppose it's something of a wash.
