Yeah, that is a bad vintage, 2.4 was a bad motor. 2010+ was the 2.5, much better (I should know!), but I kinda am on the fence about the platform. My 99 just has a better “feel”.I've been seeing a couple of 2007-2009 Camrys for $1700-3000 in ok shape but with 250k miles and "burning oil."
I'd wait if you can, and punt with a clunker if it falls into your lap.
Hit up autotempest and found a vw jetta wagon. Price is high, showed it to the wife, she chuckled. “looks just like your old car.” lol. I think mkiv looks better than mkvi but mkiv is long in tooth now.