According to Reddit, no. It seems pretty certain that if you have a PS4, Xbox One S, base Xbox One, or minimum spec PC, don't bother.
According to me, yes. I have an Xbox One X (with SSD) and the game runs very well. I've had few bugs in 6 hours, and no frame drops, even in huge firefights, driving around the city in driving rain, etc. The graphics could be better, but they're mostly good, especially at night.
But other people are saying the game doesn't look/run well even on next gen consoles, so I dunno. Hard to say what the deal is there, except that I continue my streak of games running better for me than everyone else, I guess.
People with high end PCs have the fewest complaints. I've seen a lot of people report steady 60fps with Ultra everything with no appreciable issues if they have the hardware for it. I watched a bit of a couple of Youtube LPs with good PCs, and it looked good and played well. I probably wouldn't play it on an HDD.