Take for example the dark brotherhood, you can join them and introduce a number of new quests. Or you can destroy them in one quest. Or you can avoid killing Grelod the Kind altogether. Each choice gives you less future options.
The only Aedra mission I can think of is the Mara thing.