Panama has done fine since a similar intervention.
The US didn't loot Iraq or Kuwait.
Trump is supremely transactional, so he doesn't do anything for free, but the high likelihood is that the US as a whole will spend more than it gets back in revenue, especially government revenue.