Yes, such issues are boring. But thinking back/forth/up/down do not give you the answer.
Make sure all fuses are ok, all plugs are together, all ground wires are ok, enough tranny oil, no trouble codes.
Measure current on TC shift motor powersupply and the brown wire.
The automatic transmission issue is the more complicated problem, why does it not shift,
electrical or mechanical problem.
I am not a tranny expert, but the 5R55E could have a lot of issues.
I am "feeling", it is a power supply issue...