Check what the manufacurers list, Loctite, Devcon etc. They usually have a product for different metals and situations.
I'm not proud of this but this is how good some of this stuff is.
20+ years ago a mate in NZ had an ISUZU truck (about 6.5L diesel) and due to lack of correct coolant it corroded through the water jacket/ cylinder wall on #1 cylinder and put a hole in the liner. The local agent replaced the liner and filled the hole in the cylider wall with
SILICONE! . Needles to say it leaked in a few hours.
He was desperate to get the truck back on the road for two weeks til the new replacement truck arrived so we decided to try so Loctite Metal set.
The hole was directly under a frost plug under the water pump so off with the pump and the head and out with the liner. I under cut the corrosion hole which was about 30mm dia and fitted a new liner. I put a layer of High temp metal set against the liner and a layer of water proof over that. We left it for a day and reassembled the motor.
It was a patch up job but it ran for 18 months up til the time I came to OZ, I have no idea of how much longer it ran after that.
I reckon pick the right product and prepare it well.