Duos like Simon & Garfunkel, with their signature song "Bridge Over Troubled Water," and Queen and David Bowie's "Under Pressure" are celebrated for their artistic depth and lasting influence, often praised for their unique synergy and musical genius.