So first off, let me say, that unless France went poorly, and I lost too many units, I always take Normandy on G2. So, this is kind of a new line of thought for me.
It should not be new to you. I’ve been preaching it at IP games and here on the forums since 2016. Here’s an article where I specifically mention not taking Normandy:
You are right. You cannot have fully loaded transports. However, you can have 5 or 6 transports sitting on the coast with all the troops and tanks and artillery and mech inf just waiting. It makes the Germans keep an eye on the US and slam everything into USSR or UK. It is a great deterrent.