For your old building renovation, I'd recommend stone wool - it's got good thermal performance, is relatively cheap, and handles being near welding better if you ever need that.
Fiberglass works too, it's just a bit itchy to work with. Polystyrene is cheaper, but for a proper renovation in 2026 I'd go more for the mineral fibers because they're just more durable and deal better with old building structures.
But the most important thing is that you seal the joints properly and don't have any thermal bridges - you'll save more money on that in the end than by picking between materials.