We agree to disagree then
I get your sentiment, because yes, 1UPT is limiting, but that's the point: since you are limited to employ one unit and one unit only per tile, you are forced to make choices and pick your batttles / scenarios.
I personally found war and the combat in Civ IV as downright tedious, if not boring. It was more of an industrial arms race of stack VS stack rather than any kind of meaningful military engagement.
No maneuver, no positioning, only unit composition and arms race. Well, that, and lots of repetitive micromanagement with little to no decision involved :/
I think that the solution might be at a healthy middle point between the two options, like the one suggested by Civilization Revolution. Perhaps a maximum cap of 2 different units per tile coupled with heavy attack bonuses for surrounding stacks from several angles could be the answer to that.