This is the first character focused episode that really works. The writers seem to know who they want the characters to be, Troi in particular. Riker still feels overly dramatic, but his series long motivations are satisfactorily established here. Data is further forced into the role of comic relief as he puts his bemusement with humanity on full display. The kid playing Wyatt is a really good actor and he steals the show here, but the best part of this episode is the complete lack of Wesley Crusher.
There are some stumbles towards the end of the episode when Wyatt decides to fulfill his destiny. His scene with Lwaxana which is supposed to motivate his decision isn't very believable. While it touches on the recurring theme of space, time, and thought being part of the same fabric, it does so badly. His final scene with Troi and his parents doesn't feel quite right either, but it works well enough as a farewell.
The mythology set up for the planet Haven as a place of healing has a nice pay off though I'd like to learn more about their Star Gate. Do they need a DHD or does it operate in some other manner? I don't recall if SG-1 ever visited a planet called Haven, but if they did I'll begin work on a connected universe theory. Seeing as how both shows play with parallel universes and alternate timelines it's entirely possible that the two shows share hither to undiscovered links.
Verdict: Engaging, but not memorable.
Other musings: Mr. Holm is a drunk and I love him. He deserves his own show, or at least some back story. The one-off transporter chief has a really interesting voice. A Betazoid wedding is probably a great place to notch your bed post.