This is why I think talking about hooks is silly, because either the game is engaging and atmospheric or it isn't. I'd love for someone to give me an example of a game with a great story, setting, and characters, that has a weak hook.
KotOR 2. It has a great setting, great story, and fantastic characters. But the hook is weak and gives a misleading first impression.
The player having been attacked by the Sith and left drifting through space is OK. But everything that happens on Peragus before you board the Harbinger is, amazing atmosphere aside, boring and has nothing to do with the main plot. The facility is empty of life and the mystery of how it happened is not relevant, it just gets in the way of what should have been the sole focus: Escaping the Sith.
It's only much later after you've seen the Jedi Council recording that you're given motivation to find answers/allies/revenge.
KotOR has a much stronger hook. You wake up to your ship being attacked by the Sith and is tasked to find and protect Bastila. You take an escape pod to Taris right before the ship blows up, and now you have to find Bastila and arrange transport off-planet to escape the Sith. Yes, it's copied shamelessly from the first Star Wars movie but it works.