Yes the speeds of all downlink interfaces between the MHO and Security Group members must be identical. This is because the load distribution hash function on the MHO assumes that all interfaces have equal speed capability and there is no way to weight them for differences in bandwidth. If doing mix and match you can weight the distribution by CPU processing capability but not bandwidth. I don't see a problem with dropping a 100G-capable interface down to 40G to match other Security Group members.
In theory, I'd assume that if the downlink speeds were different (let's say a mixture of 10G and 100G interfaces to make it extreme) things would probably work OK in the Security Group until the load increased to the point where the 10G interfaces are saturated (or starting to get overrun if not fully saturated ) but the 100G interfaces are not. This would probably lead to strange-looking performance issues for some connections and not others depending how they were distributed. Not fun.
Attend my 60-minute "Be your Own TAC: Part Deux" Presentation
Exclusively at CPX 2025 Las Vegas Tuesday Feb 25th @ 1:00pm