My understanding and I'm in your state:
OSB + reflective coating - this is an excellent reflective barrier, but to be effective, you need an air gap between the radiant barrier and insulation. Traditional "attic" design allows for this gap, as the attic is the air gap and typically has vents.
A metal shop is not like an oven any more than an uninsulated stick and brick house is an oven. It's all about how you insulate it and how reflective you can make the roof. IMHO, a highly reflective steel roof is superior to a composite roof, OSB, and a radiant barrier.
Shop not going to be condition space, so going try make it as comfortable as possible without adding AC.
Dude, you're in Texas. You're gonna fry without AC. Even if you build Yeti cooler to R40. It's just about "how long does it take" to reach ambient temps. Maybe you can survive in the evenings if you can move air through the building... I'm just getting to be an old man.
What's your building design? Size, height, etc?
Spray foam is expensive. Absolutely. But you can do some "budget" combo of insulation like 2-3 inches on the roof deck, insulate the walls with bat yourself, and then over-HVAC a bit (inverter/ductless) and you'll have a structure you can live in. Even if you can't write a check for it now, design for it so you can slowly add...