No vaccine has 100% efficacy per this story:
Congressman tests positive for COVID after receiving second vaccine dose
But, in answer to Coffeebean's question, yes I would get the J&J version if that's all that would be available. And the congressman in the link above may remain free of symptoms but could pass on the virus.