Rare cases yes. If I was an admin for a website I'd use 2FA, just to prevent an accidental "oops I somehow leaked my password" situation. It's the responsible thing to do as an admin.Even with a strong password, 2FA may still help in rare cases. That is, when you use 2FA via two different devices, and only one of those devices gets compromised.If you have a unique password that can't be guessed, then 2FA does nothing for you.
That would deflect almost all casual wannabe script kiddies. A dedicated hacker has tools to infect phones and break the 2FA easily. Such as state sponsored hackers, but then if state sponsored hackers are after you, eh. You're pretty screwed.
Point being, 2FA is absolutely worth doing in certain situations, but not all. Nobody could possibly have hacked into my forum account without actually knowing my password. The problem is leaked passwords on the one hand and the law of diminishing returns on the other.