I've tried a variety of compost turners over the years, from simple pitchforks to custom turning tools. But the only compost turner/ aerator I've used for the last 5-6 years is the Compost Crank. It's deceptively simple in it's design, it somewhat resembles a large corkscrew, but it will do a great job of churning almost any kind of compost. If you get it stuck it just backs out by "unscrewing" itself from the pile, and you try again. I keep it in the shed next to the garden, and in the active months when I go out to the garden I just grab it and give the pile a quick turn.

The unit is built by Lotech Products and sold by many retailers, but I don't know of a national chain that sells it so you will have to look around. They are hand built, sturdy as can be, and mine has lasted years and it still looks like new (in fact if you don't use it the end may start to rust slightly, but if you use it often it even looks better.) It's made of 3/8" solid stainless steel, so it is nearly indestructible.

No affiliate links here, just a great product I have had a lot of success with.