I've used it in my bikes and cars. I live in the high plains of west Texas where I can experience +40 temp swings in a day. I ride year round and have noticed very significant pressure changes in my tires when using compressed air compared to Nitrogen. Most on here will tell you N2 is BS, and compressed air is the same, but I call that BS because just using the pressure sensors alone, I have witnessed the differences.
"Dry Nitrogen" as you mentioned is just a good grade of Nitrogen. 100% Nitrogen will contain no moisture and is "Dry". It is the moisture in compressed air that is what is expanding with heat and causing the pressure changes. When using good quality Nitrogen you won't experience near the pressure changes. You may still see 1-2 psi difference, just because of the residual "air" that remains in your tire when filling with N2. To properly fill your tire, you should deflate the air, then re-inflate with N2 and repeat this cycle a few times.
You can reduce your pressure fluctuations with CDA if you have a compressor with a few stages of driers on the output. However, very few shops have adequate driers, and many riders just fill up their tires with their compressor that they have at home, which may have no driers on the output at all. You would be amazed at how much moisture is trapped in a compressor when the air is compressed.