Enhancing Photocatalysis: Understanding the Mechanistic Diversity in Photocatalysts Modified with Single‐Atom Catalytic Sites