In the books, the dichotomy between them is pretty significant. Boromir gave in to temptation to use it to defeat his enemies and was killed because of it. Faramir did not, suffered a bit for not having that weapon, but survived and was rewarded in the end. They were extremely clearly intended as a moral lesson.
The movies completely reversed Faramir.