Thanks @Favvz for this wonderful summary, I really took my time to go through it.
In general, while considering the employment of an oracle, the trust model must be carefully considered. You may be sacrificing the smart contract’s security by exposing it to potentially incorrect inputs if we presumed the oracle can be trusted. However, if the security assumptions are carefully considered, oracles can be valuable.