Mini would not start, no power to the coil pack from the green wire from the DME cable, checked this morning by the interior fuse box and discovered this

You found your problem, by the look.

I’m hoping so I might need a fuse box couple of the pins was rotted off

That would probably do it! Lol
maybe you can source a decent plug from a wrecked one or something to save a few bucks, but then it depends on the other end too, you may need a whole replacement part. Is that the fuse box or footwell module? If it’s the fuse box, I stick with possibly finding a replacement at a yard or something. If it’s the FRM (footwell module) that may need to be new. But it’s possible to get them refurbished. Mariokart gave me the info for a place that does it. Let me know if you need it.

I replaced the footwell module 2 weeks... it’s the fuse box by the passenger side

Ok, well in that case, you may very well have a good chance to find a used one in good shape on the cheap