I never read the details, but I know that several SQL MVPs consider MERGE in SQL just a feature to check a box in the product presentation brochure, not to be used in real life. Brent Ozar talked about this a few times, foe example.