I still don't think so
People will go out there for the same reason people have gone anywhere new throughout history: elbow room, search for new resources, to escape from something bad, and in later years of history, to find political freedom and to make scads of money.
..
The distant ancestors of the American Indians did not cross the Bering Bridge to colonize the New World for humanity. They were either following their food supply, or maybe just running from something behind them. But the job got done nevertheless.
But we are speaking of something qualitatively different, since in history, people have been going to new places on our sweet hospitable earth, not into a hard, radiation-soaked vacuum ..
and yes of course these pioneers endured incredible hardships .. but they still didn't have to worry about losing their air to a microfracture in their sealed environment, or dying due to radiation overdose!
That's where I really think proponents of this point of view are mistaken, including even Zubrin (in his longer-term views of space exploration). Think of the really tough places on Earth, like the Antarctic. People went there to EXPLORE NEW VISTAS, and now they go there either for scientific reasons (eg astronomy, geology), or for tourism - both of which are sufficient and admirable motivations IMO.