Update: Job done, I ended up putting 2 M16 bolts through the wall and the joist on the other side, anchored with resin, packed and fixed with square washers. Quite fiddly, I had to go in at an angle because lack of clearance to get the drill between joists. But it's rock solid, definitely isn't...