Hi/welcome.
" where a huge turbine farm captures energy from the prevailing, endless winds. We stopped overnight in Moses Lake, where the wind simply never stops (and I have a friend in Ogden UT where evidently it's just the same way - 40 mph winds every single morning, and lower sustained winds most of the time)."
Cool - well be passing through moses lake on our way to Guemes Island this year.
"I know that among the objections to wind turbines are these: the appearance ("unsightly"; NIMBY), and the risk to birds from the spinning blades."
Rubbish... wind turbines are beautiful things, they are (or should be) very quiet - and the whole bird thing is way over the top. There have been a few minor issues but overall it's fairly insignificant on most sites. It's nothing compared to the damage done by more conventional ways of generating power.
"Yet we never even think about the squirrel cage vents on our roofs, and I have see houses with a row of 5 or 6. Nobody even looks at them."
Actually it gets thought of pretty often...
"For an urban area like Moses Lake or Ogden, where the wind never stops but true bladed turbines might be objectionable for visual reasons (neighborhood covenants, city codes etc), why couldn't small generators be hidden inside 'squirrel cage' spinners, trickling multiple small charges into a battery bank?"
It would work - but the power available would be insignificant compared to the power that folks use.
"What could one hope to generate with a row of...4 or 5 such spinners? What could be run? (Kitchen fluorescent lights? Track lighting? A few strings of holiday lights? A fan on a natural-gas furnace? Something larger?)"
Probably none of those things unless it's hurricane force winds.
"Could the cost to set up be recovered via power generated over time?"
That's the good question here and I would say... probably not - or at least, it would take a very very long time. It would not be cost effective.
So far as wind power is concerned, the most cost effective solution for urban homes is for them to conserve everywhere possible, and then put large wind turbines on good sites in rural places and bring that energy in on the power grid.