The trick in used car buying is not to handicap yourself by shopping only one brand. Worse yet if that brand happeneds to be Honda or Toyota as they come with a hefty premium but the reliability is not guaranteed any more than other brands when it comes to used.
In April I sold my 07 Ford Focus 2.0L, 5 spd manual for about $2500 with 110k miles, ice cold AC and everything in working order. It had a minor valve cover oil seepage and the struts and breaks would need to be changed in near future, but that was about it.
Would OP even consider a car like this? Many don't, but it is a far better vehicle than that gen Civic and would've easily lasted to OPs goal of 200k miles with minimal effort because these cars are easy to work on, parts are cheap and they dont break as much as people believe.