Depends on ECU programming, thermostat, etc. Once I went to a 180F thermostat and deleted the grille shutters in the RAM 1500, the HEMI became more sensitive to viscosity in terms of VVT and MDS actuation. That's because, as
@OVERKILL said, I doubled down on MOFT. A 2~4cSt difference in cSt at operating temperature won't make a difference, you're right. But when your new operating temperature is around 185F to 190F down from 225F, then a 10cSt will make a difference and you'll see it manifest itself in the fuel economy taking a dip, mostly. Realistically, even running ILSAC 5W-30 in that HEMI, I'm losing around 2 MPG on average. Happiest I've seen that engine was on 0/5W-20 with the cold thermostat. I think that engine would be a very good candidate for the HPL "Overkill" 0W-20.
It all goes down to the temperature-viscosity relationship.
However, you're absolutely right: in a stock engine, it won't make a difference.
[Edit]
I also change the intake with the one from the 3.0 EcoDiesel, so now it can suck twice as much air as it did before. This resulted in better low-end torque. In practice this means that it drives like a limo now, even when towing my empty trailer that weighs ~1000lbs.