If you're very worried about missing something, there are two options you probably want: the one that makes plot markers always show on your map, and the one that makes containers with Stuff inside glow. It'll help. *says this as a fellow fan of linearity and veteran of several Bioware games*

Hilariously, I just picked up Dragon Age: Origins again tonight, thinking I'd best clear it before DA2 in two weeks.