https://www.curseforge.com/wow/addons/dynamiccam?comment=964

Resetting all cvars solved this for me before.
Try if this can also be achieved by resetting just a subset of cvars.
(You may have to log off and in again to get any effect.)

https://wowpedia.fandom.com/wiki/CVar_cvar_reset
https://wowpedia.fandom.com/wiki/Console_variables

Not sure if this is useful, but I was looking through AdvancedInterfaceOptions CVAR browser and my cvar cameraView was set to 1 but the default is 2. I switched it to 2 and it fixes the camera following issue. I can only assume that blizzard's cvar for following camera only applies to the default view and the issue seems to lie with the view switching on NPC interactions and not correctly switching back to view 2

Hey, thanks a lot! I will check this out.