I bought my Mazda 626 2002 used in 2003 with 1500 miles, ran the heck out of it from state to state for three years with no problems what so ever.
It was such a great car that when my daughter needed a safe car I gave her my Mazda because it was safe, reliable and perfect for her.
She is still driving it today with no problems other than regular maint.
It has well over 100,000 and will likely last another ten years. I have looked and looked to purchase another one for myself and can not find one for sale (I suspect they have stayed in families, just like mine.) Excellent car!
FYI mine was not a manual