Apparently there were studies on adenovirus 5 vector vaccines against HIV in 2007. The vaccine was not successful, but I cannot find any data on long-term adverse effects.
Plenty of replication deficient things cause cancer, for example asbestos or igf-1. I highly doubt you can rule out accidental crosstalk between elicited immune antibodies and every oncogenic human receptor.
mRNA vaccines are a new way to cause the body to develop an immune response - it's not using dead/deactivated tissue of the virus that the body detects and then its holistic system develops a response to. From my current understanding with this new type of vaccine it's skipping step(s), bypassing mechanisms, that leads to the body producing something that targets the "spike" of the virus - basically making it inoperable.
I don't think we know long-term how this may impact the immune system: does bypassing certain systems/mechanisms cause other problems with future immune response?
It took how long for us to realize as common sense that use of antibiotics allows superbugs to more likely evolve?
Vaccines are not the stock market. No one doubts gravity because "past performance is not indicative of future results".