That is actually a common misconception. Detonation is generally unrelated to coolant temperature. Intake temperature is a different story.
Not really.
You are correct in your initial post that a lower thermostat doesn't lower intake air temps. I've honestly never heard anyone claim that was the reason to run a lower thermostat.
You run a lower thermostat to lower the overall operating temperature of the engine which does lower the detonation threshold. This is well documented, no myth or theory - but not the best idea for a daily driver.
Engine temperature is a balance. The hotter you can run an engine the more efficient it will be (to a point...). A hot engine is great for gas mileage but also increases the detonation threshold.
The cooler you can keep the combustion chamber, the lower the detonation threshold is going to be. The best way to keep the combustion chamber cool is to lower the operating temperature of the heads (oil squirters also help by lowering pistons temps).
The problem with this (as you already mentioned) is an engine that never reaches 212F will not boil off the condensation that has accumulated in the oil. If you've ever seen a "peanut butter" build up in the oil filler or on the dip stick - this is a sign of condensation issues (could be other things too, just an example)
This is why short trips are so bad for an engine, just because you coolant gauge shows the engine is warm, that doesn't mean the oil is up to temp.
I've owned cars with a temp gauge for both, and most would be surprised how much longer it takes for the oil to reach full temp, especially in winter. This is why most production cars have oil coolers in the radiator. This approach has more to do with getting the oil up to temp quicker than a better cooling.
Also, just dropping in a colder thermostat doesn't tell the computer anything other than the engine is running colder, which it's not properly mapped for. In order to see any real gains with a colder thermostat you need to re-tune the engine for the colder operating temps. With some vehicles (older speed density Fords come to mind) if you keep the engine below 180F or so, the engine will stay on the warm up map and run super rich all the time.
On cars with stand alone ECU's, you can setup a warm up map that brings the oil temp up to 212F + to boil off any moisture then keeps the engine at a specified lower temperature with completely different ignition and fuel maps for each range and everything in between.
Bottom line is, the colder you can keep the combustion chamber the more aggressive you can get with the ignition timing to increase power. In boosted cars (like the Grand National mentioned above) this is huge.
Yes lower intake air temps are important but the temperature of the combustion chamber is just as important if not more so.