It is clear the MRNA ones are better.
Viral vector-like AstraZeneca, and probably also Johnson & Johnson & Sputnik 5 are not as good at preventing transmission. This is why the infection numbers are so high in the UK.
Both vaccines are good at preventing death, but MRNA is much better at preventing symptoms- as well as reducing transmission.
This table was from some universities in the UK. It is just sampled data so probably not 100% accurate, but as a trend, it does show MRNA to be superior.
AZ on the left side (1 jab vs 2 jabs), and MRNA on the right side. (1 jab vs 2 jabs)