The "wall" issue is hopelessly politicized, from outside it looks extraordinary,and that is clearly affecting this discussion.
Yes.
Some think the wall is crucial, and there's a crisis; some think it's a waste of money, and the "crisis" is hooey.
Many who think it is crucial believe a wall would completely solve illegal immigration, drug trafficking, human trafficking... even though DHS reports most of that activity occurs at other ports of entry (NYC would be an example). A subset of these seem to think that the existing U.S. labor force could possibly fill all the jobs immigrants are willing to do (as if some young millenial is willing to harvest crops, work in car washes and landscaping jobs, etc.). Those who believe a wall is necessary mostly seem to think it's only "Democrats" who oppose, despite the polling.
Many who think it's a waste of money are accused of being soft on the idea of border security, even in favor of illegal immigration, even though they are instead focused on supporting other border security measures DHS has asked for (improved listening and monitoring devices, etc.).
There's another category: those who think a wall is heartless, possibly racially-driven. Not sure this category has much insight into security work, what it takes to interdict various trafficking operations, program complexity and costs, etc. This group is also often accused of being in favor of illegal immigration.
In the meantime, Fed workers -- and federal contractors, who also can't work when the gov't is closed -- are the first pawns. Next comes all the work not being done (airport security, tax stuff, loan approvals for farming programs, etc.). Then the whole economy starts to falter...
It happens Congress owns the decision to budget for various programs (the Executive only implements those). A Congress with a spine -- and a clue -- could pass veto-proof legislation that could improve the border security situation.
But the trouble with "compromise" in the Legislature is that many see that as a lose/lose outcome. The trouble with a "common sense" approach is that there isn't much "common." Not many (yet) seem willing to look for a win-a-little/win-a-little solution.
-Chris