In short the pros and cons are:
scope
pros: no power necessary, extremely precise, can usually maintain a good cheekweld, weatherproof, simple
cons: heavy, bulky, eye relief can be a real headache, cheaper scopes may be more susceptible to damage from recoil, relatively higher cost
holographic or reflex red dot
pros: small, compact, lightweight, most handle recoil really well, relatively inexpensive, multiple rets, large FOV, unlimited eye relief
cons: battery powered, most will have very little or absolutely no cheekweld, fragile if dropped, some have a very short battery life, susceptible to weather conditions
There are exceptions to almost everything I listed but on average I think most of this holds true.