Yes, definitely. Every little bit bigger limits you more in where you can go, spaces you will fit, where you can park. Once you get into urban areas, width starts to matter maybe more than length.
If your main concern is getting around, see how a van conversion (Type B motorhome in the RV industry) fits your space needs. You can have those built on vans ranging from 17 to 25 feet long, and all are under the 80-inch maximum width for a "standard" motor vehicle in North America.
A van conversion on 17 foot van gets around better than one on a 19 foot or a 23-25 foot van. Maneuverability, and parkability not the slight difference in price, is why many commercial and passenger van users chose the shorter model, if it will carry what they need to carry.
On the other hand, some people decide 34 feet, or 40 feet, or 45 feet, is the smallest thing they can live in, and compromise on getting around. Many will tow a second vehicle to get around in the tighter places, after they park the bigger one where there is space for it.
Which gets to the final point on motorhome maneuverability. If you are going to tow another vehicle, it doesn't matter so much whether the motorhome 22 or 25 feet, 28 or 32 feet, 40 or 45 feet. Attaching 18 to 24 feet of a tow that cannot be backed up without unhooking so compromises getting around that a few feet more or less on the motorhome does not make that much difference.
I find 30 feet is not too big for getting around in the rural middle U.S. and in the smaller cities where roads and parking are designed to accommodate the reality that most people are driving 18 to 24 foot trucks most of the time. But in areas more urban, that space goes away, so I don't take my motorhome into Chicago, St Louis, Houston, Dallas, San Antonio, expecting to get around easily and find places to park.
But also, now alone for most of my travel, I don't need a 30 foot house on wheels, so I'm downsizing to a van that is no larger than a full-size SUV, and even that does not get around as well as my sub-compact hatchback, which can carry everything I need to set up camp, if what I want to do is just camp.