I bought this car new almost 5 years ago. Just turned 70000 miles. 4 cylinder 4 speed automatic. Have had no major problems. Transmission shifts a tad hard from 1st to 2nd when cold, but dealer found nothing wrong. Just learned to baby it for the first 1/4 mile. I find I use the manual shift mostly, especially on back roads when I want to keep it in 3rd gear, and not let it go to 4th gear. Overall very pleased.
I bought the optional side curtain and side airbags ... have not needed them yet. Base stereo is great, as are the steering wheel mounted stereo controls. Good visibility.
No doubt the 4 speed auto is long gone in the lineup (replaced by 5 speed). If you drive fast (> 75 MPH) then the 4 speed will result in higher RPMs than you might want.