President Joe Biden’s pardon of his son over the weekend marks the latest example of a special counsel investigation fizzling and raises doubts over the future use of such probes, which can drag on for years and cost taxpayers millions of dollars.