Does anyone know if the Uno or the Leonardo can be used as a Serial to USB adapter?
The Leonardo can be used as this, the UNO includes an ATmega16U2 for this purpose, so theoretically it can be used too. But I guess you question is too general to be of value for your purpose.