I can't seem to find any solutions in there. I have had this problem with N1 on Orange UK. Mostly MMS will not work, once it did.
When I used CM I had to install a 3rd party app, I used to use Handcent. Suggests this is indeed an AOSP problem?
Just tried GoMMS on MIUI 12.11. Seems to work...