If you don't like this episode.... Then you clearly have no idea what Star Trek is, and has always been, about.
I've never been a fan of Lwaxana and have always found her pointless and irritating but in this episode we have a deep and involving story that was well written. This is the episode that lets Majel show her acting talent and boy does she deliver. An incredible performance, both powerful and nuanced. If only she had more stories like that, instead of saving it till the last.
Those who think it's like a soap opera clearly haven't understood that Trek is essentially a soap opera in space. No matter, the are lots od prorammes with nothing but whizzy lights, lasers and space battles