> I don’t think that’s too rare in the US eithe

Anecdotal, but the only people I've met in the US with more than one middle name are people who originally came from another country.

Although, I wonder if maybe that is enforced by the fact tha legal forms and similar typically assume you only have first, last, and optionally a (single) middle name.