I love fantasy football. It helps bring people into the game. I’ve had a lot of friends who only watched their own team, if any at all and now they pay attention to all of their players.
For its popularity, it has to be somewhat good as it’s everywhere.
I get that it’s not for you, but that doesn’t make it bad.
Some people, who also can’t handle competition or gambling, do suffer in it as it can consume them and ruin the actual game for them. But like football, it’s just that, a game.