My Q7 is this way as well. It took a solid month of daily driving to get used to how it works. You're not a lizard brain, shits way more complicated than it needs to be. This could all just be steering wheel and dash buttons/controls, or even a Mercedes/Tesla/Rivian style stalk to control the transmission.
View attachment 203007 <--Shifter on Q7. It "rests" in park. Has two "bumps" available forward, and one "bump" available backwards. Also will slide/tilt to passenger side for manual mode. Park is just a button.
Shifter "rests" in one location. Push button and a single "bump" forward is neutral, add a second bump OR go TWO bumps on the first move and you get reverse. Single "bump" backwards and you get drive. Park is a button on the shifter. While driving forward, a single bump forward will go to neutral without the button, and a single bump backwards toggles between Drive and Sport. Also, while driving forward, from resting position, push shifter to passenger side and it move you into manual mode. once in manual a single bump forward is +1 gear, single bump backwards is -1 gear.
Now, paddle shifters. They work all the time anytime. If you're in D or S it will shift from current gear, put trans in Manual mode, and allow shifting. If no input is received it goes back to the previous D or S after a given time. Also, you can hold down the + paddle for 5 seconds and it will dump you back into D or S. In manual mode it holds the gear selected unless revs drop below 750rpm or ride the rev limiter for longer than 3 seconds. I will give Audi props for making the trans tuning in manual mode quite intuitive. As long as you don't violate the rev limit rules above it stays in the gear you tell it regardless of load or throttle position.......NOW.....a note on throttle position. There is a WOT "detent" in the pedal. If you are WOT but NOT past the detent the trans stays where it is (in manual mode), if you go past the detent it reverts back to Sport mode, downshifts and applies full power. Best I can tell this is a sort of safety feature, like a "full power to accelerate but you forgot you were in 8th gear at 40mph" type thing.
Gotta say, with all that. Stepping from the Audi to the Silverado is a step back in simplicity. Column shifter and cable throttle. Shits dead simple and just works without any confusion or learning curve. I love it.........I think I'm getting old.