Can Bitcoin Core be made to display/enter amounts in USD or other fiat currencies?
No, this is not possible in Bitcoin Core. You will have to use a third party wallet software such as Electrum if you want this functionality.
There also isn't any standardized format for exchange rate APIs, so you will be limited to the exchanges that are already built into the wallet you select.