Steve, I don’t have any direct experience with the SP dynamo hubs but my dad does. He has had the same one on his daily commuter for the past four years and it is still holding up. We live in northeast Ohio so he has taken that hub through many a salty, slushy, wintry season. He rides 5-6 days a week, about 30km a day.
I personally use the Shimano DH-3n72 and have found it to be just as reliable as his. If you’re on the fence about dynamo, I’d say hop it! The only danger is that you’ll end up wanting one for all of your bikes.