Good luck, and definitely don't replace the transmission unless it's actually broken. The valve body is a separate part and the cause of most transmission codes on our cars. Very few actual transmissions fail where the clutches are actually worn out. But since the VB controls everything, issues with the VB make people believe the tranny is toast. When one of my VB solenoids failed, my car just stopped shifting. Basically it went into limp mode and just held 4th gear. I pulled the code to investigate, but had I taken it to a shop, they would have just said replace the transmission and based on the symptoms, it would have seemed reasonable.
None of it is that complicated, solenoids opening and closing to direct fluid through channels and ports all controlled by the TCM. But it looks intimidating which is why transmission shops charge so much. Good luck with it, hopefully they can rebuild the VB. Solenoids are replaceable, but they are somewhat hard to find since they're not commonly sold separately.