I'd like to hear both sides of the full argument please of that's a real offer. I don't think he was useless, but I do think there must have been better choices for the task
I've come across a few comments (back on Reddit) where people argued that Sam would've been a better pick for the role as he does more in the movies, and yeah in the movies Frodo is a little more fragile, but in the books he does do more.
I suppose the main drive of the meme is that some downplay Frodo's role, whereas I think he is a good character and has his moments.