Reverse transcriptase is a viral enzyme. Normally you cant go RNA-> DNA. Retroviruses use it, there are only two retroviruses known to infect humans: HIV and HTLV. Both of those viruses manage to keep their genes integrated in at least some cells forever, which is why curing HIV is very difficult despite effective treatments that prevent viral replication.

However other viruses that cause persitent infection do not use reverse transcriptase. Some (like HPV) can integrate with the genome but they are DNA viruses integrating with DNA (and not retroviruses). Herpes viruses generally dont integrate with the genome but a few can (again DNA to DNA), but chickenpox (a herpesvirus) as well as herpes simplex (the one you probably think of when you think of herpes) infect nerve cells and hide out in them as the immune system usually does not attack nerves, so they persist through a completely different mechanism from genome integration.