I am very much against such additives, with just a couple of exceptions. Years ago Consumer Reports (I believe) did some testing and found Restore engine additive had some very small effect at restoring some lost compression and oil pressure to an old and ailing engine. So as sort of last ditch effort to get a few more miles out of a dying engine it might have some value. A long time back but I seem to recall their testing procedures I find fairly convincing.
All that said, if your engine isn't dying or very sick.....no.
There are two, and only two, transmission additives I would use. One is Lubegard platinum. You would use it if in a professional's opinion your transmission has "sticking" valves. I have had this stuff actually work and free up some valves.
The second is some stuff called "Shudder Fix" which basically a dose of friction additives for vehicles with lock up torque converter and basically does NOT apply to our old cars unless they've had something like a 1994 or newer transmission swapped in.
Neither additive should cause any long term issues. UNLIKE about every other one. Like Hemikiller says, they might have a short term effect but are poison in the long run. They swell the seals up so bad the transmission rebuilder will curse you and your additive.
OK, and every once in a while a manufacturer will requite some special snake oil they've come up with to add to the fluid of very specific transmissions in very specific circumstances (some Ford remans for example) but those absolutely do not apply here.
I don't call it additive but I've been known to add a quart of cheap transmission fluid to and engine that is very "dirty" and/or gummy inside. As sort of an engine flush and it has to be pretty nasty before I resort to it. Shortly before the vehicles gets an oil change is when I use it. The reason is that transmission fluid is loaded with detergents and is fairly close to 10W oil. Like adding a soap that makes nice with engine oil.
Works well on lacquered and sticky lifters too. Some folks prefer to use Marvel Mystery Oil for that but I've yet to need to try it so I have no personal experience with it.
Basically if your car doesn't have any of those specific problems. Just keep your oil and fluid changed regularly and skip all that other stuff.