Steam does automatically download updates to the DLC when subscribed. It is not placed in the DLC folder, the folder where Civ6 Workshop mods are stored is located at: D:\Games\Steam\SteamApps\workshop\content\289070 (early portion of location is dependent on your Steam install location)
289070 is the Steam ID for Civ6. All mods are assigned a number as well, the Steam ID for CQUI is 870911250, so that will be the folder number you will find within the location I pasted above.
If you still have a copy of CQUI in your DLC folder you'll need to delete that, it is a copy you downloaded and manually placed there. Having both that and the Steam Workshop version WILL give you problems!
Many thanks. checked my C drive and found Steam workshop with this mod .btw pleased to see it was updated a few days ago!
I did indeed have a copy in my dlc (now deleted) - I did notice that this was disabled (in Add Content) and it was not possible to enable. Also noticed a couple of mods that needed deleting as they were included.
in this mod. I am hoping to get my city banners (showing districts built) back and it would be nice to find the unit upgrade returns.