When it comes to betting/fantasy sports, I never have problems like you describe.
I had no issue betting what I think will happen.
I also have no issue rooting against my financial interest about what I want to happen.
I always value the Dolphins doing well over any bets or fantasy implications. Granted, if I'm betting, it's gonna be like $5 so who really cares.
This was our super bowl so I think it was $150 if I won and $25 if I lost. So while not life altering money, not an insignificant $5 either.