The best are the Trojans but Duracell bats are fine.. My cart has them and I haven't had any issues. I won't replace them when they finally wear out though as I'll switch to lithium and build my own pack.
If you plan to do a lot of golf cart riding every day, you should probably spring for the Trojans. However, if you're like me on a small farm and daily use is generally less than a mile or two of riding around and then back to the charger in the evening, then the Duracells will be fine.
Trojans will be better if you plan on deep discharges.. but if your discharges are shallow, then the Duracells would hold up just as well.
Another consideration is physical abuse.. Stock golf carts can be a bumpy ride on uneven ground.. Here on the farm, even the driveway is bumpy. In such cases, I think the Trojan's would be better.. But if your cart has an upgraded suspension and larger (softer) tires that smooth the ride out, or if you're mostly driving on smooth roads or a golf course, then the Duracells would hold up just fine.