DNA based viruses don't have that unique mechanism but the result is conceptually the same: you get a virus that is extremely hard to completely cure/remove due to it being present in some of your own DNA. Herpes is a DNA based virus and that's why you can't ever be fully cured from it.
That's also why retroviruses like HIV can only be suppressed. It's also why antiretroviral drugs try to inhibit the replication phases of the virus, which makes managing the disease possible but can't remove the virus itself. Still, a cocktail of those inhibitors is an amazingly powerful treatment against AIDS and leads to HIV becoming basically dorment in the body.
A ribovirus (which is what coronaviruses are) is RNA based but it doesn't embed itself into our genome. It never translates it's RNA and since RNA is fundamentally less stable of a molecule than DNA, you get really high mutation rates. That "instability" is caused by the lack of a built in error checking mechanism in RNA. Those random mutations are part of why Influenza is hard to build immunity against. But it's also why RNA based viruses are generally either too virulent and mortal to allow for effective spread, or rapidly evolve towards less lethal forms.
Keep in mind that I've generalized a lot and that there are a lot of exceptions and outliers when it comes to viruses. For example, Hepatitis C is a ribovirus but it has a special protection mechanism that protects it's core genetic material from mutations even if it's RNA based.
The coronovirues have a proofreader mechanism, which is interesting.
And influenza has more potent evolved countercountermeasures than just high mutation rates: https://en.wikipedia.org/wiki/Antigenic_shift
One of the distinguishing trait of CoVs are their special RNA replication/transcription mechanisms that results in less errors, which is really important considering the large size of their genomes compared to other RNA based viruses. Though, and correct me if I'm wrong, aren't they still extremely less stable than DNA viruses? Which is why only short/medium term immunity is usually possible? I don't know a lot about the synthesis of coronavirus RNA but it looks super interesting
That's correct. Worse, the proofreader doesn't have to protect all parts equally...
> Which is why only short/medium term immunity is usually possible?
No. For some viruses active immunity just doesn't last particularly long for reasons we don't understand (or at least it was described as not understood in every paper I've seen on the subject). For some viruses you can be reinfected months later with exactly the same virus. This is the case for several cold causing viruses.