Dealers have a wealth of knowledge however, will always pass over the Rodenstock Sironar Digital series to the latest "HR Digaron", is there that much difference when shot with either a 50MP (1.3 crop) or a 100MP? What about Schneider?
If you've used or have in use these lenses, I need some practical hands on review/opinions of both.
The largest improvement in lens quality in the past couple decades has come in wide-angle lens design. So there is very little comparison between older tech camera wides (e.g. Schneider 47 Super A) to newer tech camera wides (e.g. Schneider 47XL Digitar, or even more recent 43XL Digital, or Rodenstock 50HR). There simply isn't an old lens that can match the Rodenstock 32HR or 50HR.
With longer lenses the difference is still there, but is much less profound. For example the 90HR-SW is unquestionably a better lens than the 90HR but the latter is still a very strong lens.
With macro lenses (not heavily used in architecture I know, but while I'm discussing different lenses...) the difference is even less. Even a quite old 120mm Macro design like the 500 Series Zeiss 120mm (not a "tech cam lens" but works on a Cambo with the 500 adapter assuming you're using an IQ3 100mp or newer with an ES) will hold up pretty well to modern scrutiny. A more recent macro like the Schneider 120mm ASPH) is a better performer, but again, the difference is less stark.
As a separate but related topic, some digital sensors don't handle wide angle symmetrical lenses very well. So, for example, an IQ2 50mp or H5D-50c is not going to work especially well with a Schneider 28XL Super Digitar, especially with movement applied (even though the image circle spec would imply it would). Other sensors like the IQ4 150mp have no problem with wide-angle symmetrical. So do make sure you're aware of your specific model's limitations in this regard (you didn't mention which back you're using).
So if you're looking to balance budget and performance I'd stick with more recent wides, and older longs or macros.
By the way if you're working with a dealer that will "always pass over" older tech rather than trying to help you understand the performance and price of each option available to you (regardless of age) then you should consider working with a new dealer

.