When and how are pardons supposed to be used? Why does the Constitution even grant the president the power to pardon? Can it be used to pardon any crime?

On the surface, it seems to make the president above the law. CNN just reported that president Trump promised to pardon the head of CBP if he broke the law. It would seem the president could just do this for any law or policy he doesn't like and thereby bypass Congress or the courts.