You can count this as one more vote to cut your losses and move on.
However, for the sake of your wallet, I strongly suggest that you move on to a vehicle with a known history of good maintenance. I say that because both your Altima and that Accord appear to be victims of lax maintenance.
For your Altima to need a new timing chain at only 94k miles makes me suspect that this car did not have its engine oil changed often enough, as lubrication problems are almost always to blame when a timing chain needs to be replaced prior to…let’s say…200k or 250k miles. Even if you were using the oil change interval specified by Nissan, if you do a lot of local, short-trip driving you need to change the oil at least every 4 months in order to avoid sludging and related lubrication issues.
Similarly, if you need a transmission rebuild at 94k miles, that points toward probable lax maintenance of the transmission. Even if the mfr’s maintenance schedule doesn’t specify it, trans fluid (& filter) should be changed every 3 years or 30k miles. Has the trans fluid been changed at least 3 times already? If not, that is the probable explanation for trans failure at 94k miles.
And, also similarly, if that Accord needed a trans rebuild at 92k miles, that indicates lax maintenance on that car. In other words, it looks to me like you would be going from one poorly-maintained car to a different poorly-maintained car that will likely also cause a hole in your wallet.
I suggest that, instead of focusing on the legendary reliability of makes such as Toyota and Honda, you should focus on finding a car (of virtually any make) which comes with full maintenance records that you can compare to the mfr’s maintenance schedule, in order to verify proper maintenance. Then, once you find such a vehicle, you still need to have your own mechanic do a pre-purchase inspection in order to detect incipient problems and possible collision damage. And, of course, after buying it, make sure that you maintain it properly!
What I am suggesting is time-consuming, but in the long run it will save you a huge amount of money.
Buying a poorly-maintained car, and/or not maintaining it properly after you buy it, is invariably a lot more expensive than simply doing basic, scheduled maintenance when it is supposed to be done.