I recently asked a question that has multiple correct answers, each with their own pros and cons. Nick's answer uses recursive CTE's to provide the solution as efficiently as possible, but Sebastian's is much easier to implement, debug, and make changes to (very important in my work environment). Since neither is technically wrong, how should I decide which is "most right" when it comes to formally accepting the answer?
Pick the answer that you used.
This is expanded on here: https://dba.stackexchange.com/help/accepted-answer
as "Accepting an answer is not meant to be a definitive and final statement indicating that the question has now been answered perfectly. It simply means that the author received an answer that worked for him or her personally"
Pick the answer that will be most useful to future visitors. Most questions have dozens of interested visitors with the same question. The asker is just one of them.