I don’t think Alex meant that you would have to create an output preset per printer. But you probably do not need to have an output preset per printer type. Perhaps an output preset per printer with a certain configuration. For instance, Printer type X with 5 trays, and Printer type X with 15 trays.
You would then want to have tray mapping in that output preset for all the paper types that you want to use on that printer.
For printers that have a generic way to select trays (IPDS, PCL, generic PostScript, and a some specific printer definitions), that would mean that you create entries in the tray mapping table of the output preset. In case of PostScript printers for which you have a PPD, you can create a printer definition from the PPD, and use “Dynamic PPD mode”.
To control this from the data, you would look at setting up media types in the templates that you use for Content Creation. If you have a template per (group of) document types, you often just configure it directly in the template’s Media and Sections. For the media, it’s best to choose good names, and also set the Media type in the Characteristics. If you use “Media 1” in every template, but it actually refers to a different paper type, then that’s probably going to make things difficult. It may make sense to also explicitly set the color and weight attributes in the Media’s characteristics, but often the size and the type are enough.
It’s also possible to use scripting to choose the media type for a section. If you are using a generic template for all/most of your output, then that’s probably a more effective way to get it done. In any case, you would be explicitly configuring the every Media that can be used by a certain template.
All of the above is the most generic approach that will also work for jobs where you have to be able to switch trays on a page by page basis within a document.
This will allow you to get the print job with the right tray selection. You can use Connect Workflow to send the job to right printer based on the data.
If you can print the stationery with the job, instead of using preprinted paper, you may be able to reduce the number of trays (and perhaps printers) that you need. Connect has different ways that you can add stationery as a background. One of them is in the Media of the template, and is called “virtual stationery”. Every output preset has a checkbox that will cause that stationery to be printed with the job.
I hope this helps you move forward.