Advice

[steve davidson]

Odd that it would shear but not the strangest thing that will ever happen on a Seven. Both above replies sound pretty good to me, with respect to Simon’s idea I’d suggest the magnet be augmented by a vacuum as nothing good will come from anything falling into the crankcase. It will be tight to get a normal drill in there so a right-angle drill might make things easier. You might need to sacrifice a drill bit and cut it so there’s only 10mm projection from the drill body, that will make it easier to get in to this tight spot.
If you can source it using a reverse drill bit would be a good idea, often just the heat generated by drilling combined with the reverse location is enough to get threads moving in the right direction.