I have to say I love WYLB. I think they wrapped up the storylines they needed to and were clever enough to focus mainly on the characters. It was a very emotional episode for me, and it was sad to see the show go.
Probably my biggest complaint about the episode is the battle in the firecaves. That was just really anticlimactic for what they had been building in the that storyline, I felt. And I'm saying this as somebody who actually liked the whole storyline about Dukat going mad.
Looking at Star Trek, I really feel the shows got the finales they deserved. DS9 had a complex, involving finale that focussed largely on characters and brought the long-running war to an IMHO very satisfying conclusing. It wrapped up a lot while leaving enough open to make it exiting to think about what might happen next aboard and around the station.
TNG's finale was built around an anomaly in space and time, weaving in the characters with Picard at the center of attention. And everything's nicely wrapped up at the end. It's a very well-thought out predicament the characters find themselves in, and exciting to watch. But it leaves very little to ponder about, I think.
VOY's finale has the ship blasting a few Borg vessels before suddenly arriving at earth. Everyone goes, hooray, and the screen fades to black. There's no follow-up, no emotional reward to the end of this seven year journey. But then, what was there about these characters that would have been interesting to see after they'd arrived? IMHO they'd never been developed enough for it to even matter. In the end, the finale was just as shallow for me as most of the show. All effects, no characters.
ENT's finale is probably even more poignant. The characters are reduced to Holodeck recreations, and the Captain's speech is cut off at the whim of one Commander Riker. As others have said, it's really a TNG episode. Personally, I never felt this was a loss. Because, in the end, I never really felt any kind of attachment to these characters at all. They never actually developed 'character' for me. And the finale seemed to suggest (at least in my view) that the writers basically felt the same way. Who were these people anyway, might be a fitting question.