Gearheads! Q for you on diff model makes and issues?

Warning: I'm NOT versed on cars and the following question may make you say you flipping idiot.

I once had a 98 and an 02 Mazda 626. The '98 gave me nothing, but headaches and after checking car complaints everyone had the same headaches as me.
Well, I have a '06 Mazda 3 as an option for a second car. Someone said Mazda 3's are super reliable and this make and year was given an awesome seal on car complaints.
I'm scared of Mazdas due to my past sh#tty experiences. Is it silly to steer clear of all Mazdas or is it possible the Mazda 3 could still be good? Please explain this?
Note: I know about Honda and Toyota being awesome, but that is not the car thats being presented to me.

I have heard similar from various people including a couple friends who work at mechanic shops.
Mazdas of long ago were nightmares. More recently though they have started making some very good cars.

I had some bad experience with a Nissan Sentra before, so I will never get another one. We tried a Honda Accord and it lasted a very long time, we're only on our 2nd Accord and 15 years still running strong.
So learn your lesson from your past experience, if you want a reliable brand, then try a Toyota or a Honda.
Mazda 626 uses the same chassis and some parts as the Ford Probe, and you know what they say about Fords.
Yes Mazda had made improvements lately, got some good feedbacks, but their reliability doesn't last that long.
An 06 Mazda is already way past its prime, reliability will be an issue, going on 9 years with how many miles?

I've never heard of a happy Mazda owner. Why do people buy those cars anyway?