I'd be fine if a wall existed on the US/Mexican border. The cost and effort just doesn't seem worth it.
There's already a wall or fence along most of the border. Everybody seems to forget that. I really don't see the need to replace it, but I'm not one of the contractors that would get paid vast sums of money to build the new one.