The Discovered Eridian Promontory trophy in Borderlands: Game of the Year Edition is story-related and can't be missed.
You will automatically reach this location towards the end of the game prior to fighting The Destroyer, the game's final boss. Once you enter the area, the trophy will unlock.