DUI checkpoints don't catch drunk drivers. They catch unlicensed drivers. Next time you you roll through one, thank the police officer for keeping the community safe and then ask how many drunks they arrested that night.
That doesn't seem too terrible - we want unlicensed drivers off the roads too don't we? Whether or not they can drive well, they will be uninsured, which is clearly a risk to everyone else.
Exactly. They make their real money as a pretext to issue petty citations to people they wouldn't have otherwise stopped. Actual drunks are just the pretext. Sure they'd be happy to catch a few but they're the bonus not the goal.