The current mRNA vaccines are moderately effective at preventing Covid infections, about on par with current flu vaccines.
Not all vaccines are equally effective, but none of them are 100% effective at preventing infections. The only thing vaccines do is prepare the immune system for an infection. Since SARS-CoV-2 mutations happen a lot faster than (for example) measles, Covid vaccines are a lot less effective - by the time you're infected, the infection is dissimilar enough to what the immune system was prepared for that the preparation is no longer optimal.
And yet there are still people that think it was supposed to in the first place. Thinking that makes it a failure, at least you don't think it's full of mind control tracking nanobots though. :D
Or maybe you are, since you used scare quotes. It's probably too late to share any facts with you at this point...
MRNA vaccine is highly effective at reducing symptoms and saving lives of those at high risk (e.g., over 65), but it was never effective at preventing infection or stopping transmission. People who were saying that were somewhere between being over optimistic, and spreading disinformation to try to increase uptake.
Studies showed it decreased infection and transmission against the original strain of Covid.[0]
It lost effectiveness against delta and then became nearly ineffective against Omicron (although still helping with reduction of hospitalizations and deaths).
Non-mRNA vaccine is available now (Novavax) and the effectiveness, or lack thereof, seems similar.
"It is now clear for men <40, dose 2 and dose 3 of Pfizer have more myocarditis than sars-cov-2 infection, and this is true for dose 1 and dose 2 of Moderna."
You need to analyze the total risk of both options to state that getting vaccinated is more dangerous, not just the risk of myocarditis following each.
Not all vaccines are equally effective, but none of them are 100% effective at preventing infections. The only thing vaccines do is prepare the immune system for an infection. Since SARS-CoV-2 mutations happen a lot faster than (for example) measles, Covid vaccines are a lot less effective - by the time you're infected, the infection is dissimilar enough to what the immune system was prepared for that the preparation is no longer optimal.