Why Some Google Sheets Formulas Use INDIRECT() Instead of Direct Cell References

When I first learned Google Sheets, I assumed the shortest formula was always the best one.