A mystery really motivates me such as what the OP mentioned in their post. Or like in BG2 when you wake up in Irenicus's dungeon and you're trying to work out who this guy is, what's happened, why you're locked up, what all these people in jars are doing etc. Then you finally get out of his hideout and then he disappears!
