It's not really about picking just one material - it depends mostly on where you need to insulate and what your current situation is. For a reno from the 80s with a tight budget, rock wool is still your best friend: cheap, easy to install, it does the job properly and holds up well over time. Wood fiber is nice if you want something more "eco-friendly" and it insulates better acoustically, but it costs more to install for the same performance.
Polyurethane is overkill for most people - excellent insulation but the price shoots up and honestly for a house like yours, you'll hit your energy goals way before you'd need to go that route without breaking the bank. If you need compactness (like really low attics), then it becomes worth considering, otherwise honestly forget about it. I'd say rock wool everywhere you can, period - you'll get better ROI on your budget that way.