That's odd. I have the other three Unlikely Heroes quests. I would of thought they would all unlock at the same time. I got the first three all at once.
You probably didn't have Creeplight Ruins unlocked when you hit the trigger condition. It'll show up when Creeplight does. I've had the same thing happen to me.