William T. "Puppy-dog eyes" Riker? Uh-uh. Right from the get-go I didn't like him. I watched him get saucer-eyed about the cool way the ship's computer would give him directions or tell him where people were, and immediately wondered, "Hey, you just transferred off another starship - why didn't you notice all this cool stuff there?"
Because the Enterprise-D was
supposed to be state-of-the-art. The ship's computer and the holodeck advancements were unique to that ship, at the time. There was a premise-change after "Encounter at Farpoint".
As scripted, the Enterprise was not going to be returning to known space after departing Farpoint. That's why Q stopped them.
It was a supposed to be a mission of perhaps ten years duration. For some reason, Starfleet did not proceed with that mission.