Well, you might think more about operations. Generally yards are not the focus of the operations, the industries along the line are. And industries along the line add a lot of neat scenery in many cases. Yards are just devices that are used to support the operations to the industries and a nice operating scheme could be done without yards at all.
I have found that 48 inch radius works fine for many steamers in O 2 rail. For PRR models, many of the prototype and many of the models up through 4-8-2 had blind drivers so they go around curves quite easily. I am not familiar with Santa Fe stuff.
Generally though 2-8-0s and smaller would probably handle 48 inch radius very easily and depending on loco, probably tighter. Mikados would probably be a 50-50 guess but I am thinking most would work. My PRR mikes do not have blind drivers and do fine on 48 inch radius If you go bigger to mountains or 2-10-4, then you will have to check each one out. I have a few Sunset GGD brass steamers and they not problems with 48 inch radiuis and most would probably go tighter except the 2-10-2.
40 and 50 ft freight cars will be fine on 48 inch radius and probably work down to about 36 inch, especially 49 ft cars. And these work with body mount couplers. Newer GGD 80 ft passenger cars, or older Walthers cars will go around 48 inch radius without complaining. Many brass 80 ft cars will not without modification. These usually have a lot more underneath detail and that stops the trucks from swinging far enough.
I think any 4 axle diesel will handle 48 inch radius. I prefer single motor drives and mine handle 48 inch radius with no problem. These include weaver and all nation units. The locos will go around 36 inch radius but the coupler swing becomes a problem at some point. I think it would work on 36 but not less. I also have GGD E7s, SD7, and PAs and I tested them on 48 inch radisu and they ran fine. My main line has 52 inch minimum and my branch has 48 inch. Newer Atlas and MTH 2 rail stuff has the truck mounted motors and will go around sharper curves more easily in most cases but in my experience to not run as smoothly, all else the same.
Brass 4 axle diesels would probably work on 48 inch raidus, but some high ends probably not.
In the old days, 40 inch radius was considered adequate for 2 rail O gauge. If you look at early John Armstrong track plans in magazines, that is what he uses. However, as models have become more detailed the radius needed for steamers in particular has increased. You could easily run 4 axle diesels and 40 anf 50 ft freight cars using 36-40 in radius and still have body mount couplers.
This is not advice, just giving you some of what I have learned from experience with O 2-rail I think you are right that O 2-rail is more available than S. Especially if you got the O scale train shows. A lot of new-old stock and used stuff shows up and there is a huge amount of variety of locos and rolling stock.