Can RTGS be used to transfer funds from overseas into a US bank?

Typically no. RTGS is usually used by banks in a country to go large settlements amongst themselves. It is pretty much a localized system. In many countries the RTGS is run by the central bank or by a semi-autonomous body. The clearing of funds with the RTGS are all based on local currency.