A tour of theta dualities on moduli spaces of sheaves