It depends on the individuals involved, and how the RV will be used.
We're in our first RV, a 40' dp, and it has been excellent for us and for our travel style. We have apx 66k on it over the past 9 years, and have seen only one other coach that even gave us a fleeting thought of trading. I had experience driving over sized vehicles years ago as a teenager, so was not intimidated by the thought of a large RV. We rarely go off-grid, have stayed in some state/national parks and COE campgrounds, and have never been unable to stay where we wanted due to size, though we sometimes had to be selective in what site we chose.
Paul (KE5LXU) ...was fulltimin', now parttimin'
'03 Winnebago UA 40e / '05 Honda Odyssey toad