That's not a dumb question at all. It's an excellent question.
All things being equal, a water to air intercooler is VASTLY superior to an air to air unit. They will always outperform an air to air unit.
The reason why they aren't commonly used? Primarily it's complexity, reliability and...