It did have some interesting dream sequences, although in my forthcoming season five review, I point out that they actually make an elementary mistake in the filming/editing of Troi's dream.
Violations has what may be the worst cut to credits in the entire series run. And its villain has no clear motivations, it relies on a contrived plot convenience to allow the son to frame the father, and they only catch him because he decided, for mysterious reasons, to attack Troi again, but this time by going to her room. There is also almost nothing at stake, because the dream, while mildly distressing, just puts you in a coma for a couple days. Then you wake up from it, don't remember the dream, and can get on with your life.
Illogical plot and complete lack of important stakes. That's bad script writing.
But I agree with you, the dream sequences are interesting in isolation.
I think the Villain's motivations and behavior are very similar to that of pedophiles who try to hide their deviance from their family and acquaintances and sometimes succeed for years but at the same time are constantly driven by their obsession which leads them to do things that get them caught because they are impossible to hide. Troi's final assault seems believable in that light.