A lot of good answers already so I don't know how much value my comments will add. I'll just be blunt and saying having AN/DP (or equivilant) training AND experience before trimix is absolutely critical in skills development. Consider it a valuable stepping stone. Of course I'm also one for saying proper mentoring and self-learning can help you develop these skills but the class will get you there much sooner and safer. If PADI, TDI or GUE can get you here, great.
You can still get yourself into significant amounts of deco (and trouble) between 100-150'. It's always a good idea to build on that progressively to see how your body reacts to decompression, progressively deeper depths and narcosis. In the Great Lakes cold is a factor. Are you prepared to do an hour of decompression in 38-40f water? Appropriate undergarments, active heating? How does your body react to 30 minutes of decompression? Are you more susceptible to DCS than others? How do you feel/react at 150' of 38f water?
When you start getting into the normoxic trimix range it's not unheard to have upwards of an hour+ of decompression time staring at you in the face. Not a good idea if your longest decompression dive has only been ~20 minutes.
Onto your original question:
I'm wondering whether AN/DP (or the equivalent PADI courses) provide a certification and skills that are useful by themselves for real dives, or if they are better understood as stepping stones to trimix certification.
They are absolutely useful by themselves. Getting comfortable carrying stages bottles, switching gases, holding decompression stops, planning dives/tracking gas consumption, lost gas plans, decoing on backgas, tracking OTUs/CNS, building experience at depths (100-150') with real decompression.
Also, having access to O2 (or even 50% for that matter) to do decompression at even recreational dive depths provides a huge advantage. Maybe you already do this? I don't mean to make assumptions but a card will make it easier for some boat captains and insurance to digest.
A lot of us take for granted that we can punch some numbers into MultiDeco and have it spit out a a master plan for us to follow or strap on a couple Shearwaters and go diving. Truth is neither of these prepare you for going through the motions and actually executing the dive.
I can punch a plan into my Shearwater for 350' dive and the numbers can look good; It doesn't mean I can safely execute without some significant build up dives.