Sorry you are having issues. Total failure of these transmissions is rare. They generally do a good job of shutting down before serious damage occurs. But most shops don't want to risk just changing a mechatronic and thus will require you to change the complete transmission.
What engine do you have? Under $5k is probably possible. Pickup an ebay used trans with warranty. Have it installed. Code new trans to work with your car.
If you decide to sell it let me know. Your yard looks like Phoenix
.