Credit card balance transfer fees can be worth it, but, in certain situations, they might lead to more debt.