Does everything really need a main plot?

Does everything really need a main plot?

Weak main plots can drag down otherwise enjoyable games and prevent players from creating their own fun. So are they really all that necessary?