J&J's excuse for 66% effectiveness is that they were tested when there was more Covid going around? That's exactly when the vaccine is supposed to protect you. Not when there isn't an opportunity to catch the disease.
And if we then take this claim on its face, then Pfizer and Moderna vaccine stated effectiveness is pointless, since it wasn't tested during the worst times.
Finally, the claim that no one in the study group that did catch the virus ended up in the hospital is also based on self-selective bias. I am assuming people in the study were younger people who needed the money and not older folks who are at a higher risk. I am not saying that it's not true - just that the biases need to be taken into account in any study.