I realize everybody has different experiences and all...
My wife bought new an 03 Mazda 6 and we still have it. It's the 2.3L automatic. Yes it's slow, no it's not sporty....but that's not what we have it for. We put a good amount of use on the car - it's currently just over 110,000 miles of our use - and have had a good experience with it.
The brakes (at least on the early cars) tend to wear out pretty quickly, and we had a vacuum tube split behind the intake manifold that was a pain in the ass to change, but other than that we've been trucking for quite some time with that car and I fully intend to drive it until it's completely broke and busted.