It does depend on how they implement them. Driving around in a sandbox environment like Fallout isn't necessary or productive to the story of your character, but driving in between nodes and leaving your vehicle to travel a map on foot allows you to experience everything the developers wanted you to.
I respec your opinion but I disagree with your claim that vehicles prevent your from experiencing everything the devs wanted you to. The devs made the world for us to enjoy, how much of that we want to enjoy is entirely up to US the gamer. If the devs wanted us to experience every little thing then fallout would be on rails with every side area being gone to via the main quest.
As the game stands right anyone can skip over 90 percent of this game and if that is how they want to play then I say good for them. I dont tell them they are doing it wrong because quite simply there is no wrong.
Vehicles can be done as tied to the character or as just another mode of fast travel. If tied to your character then they become essential to the story of the character making that point in your post moot. If they are done as a form of fast travel then they in no way shape or form detract from your gaming exp as you can ignore them just like you can ignore the current fast travel already in game.
Anyway you are anti vehicle I am pro vehicle. I doubt either one of us will change the other persons mind but I do love going back and forth over different approaches and takes on vehicles, motorized or organic.