No, windows doesn't change the name of the folder if you change your windows username. It still has the name of the original username....
Feels like a real hassle creating 2nd users, reinstalling game etc etc.
Yes...
But it's a simple matter to fix this.
A) rename C:\Users\YourNewUsername\Documents to C:|Users\YourNewUsername\foo
B) move C:\Users\OldUsername\Documents
to
C:\Users\YourNewUsername\
Or some similar variant thereof.
========
And this is extremely strange.
Several other folder names are located under your username -
Documents as has already been covered
And I believe - Music, Pictures, Downloads, and perhaps more....
At any rate, if you create a new user and then fix these issues it will work - a bit of a hassle to be sure. But doable.
OtOH - it's really weird that Civ4 is able to find a lot of things under your username with extended characters - e.g., Saved Games, but cannot load mods if they are underneath this same directory. Yeah, it's possible... but weird.
Anyhow, I'd recommend going with a new username and fixing the "My Documents", "My Music", "My Pictures", "My Video". issues - shouldn't be hard with renaming/moving.
Also check "downloads" and maybe some other things.
Once you move everything I'd delete the entire old username directory altogether.
If any errors crop up it shouldn't be too hard to fix.
=================
As an ex-Microsoft developer... I really find the behavior of not renaming the default username directory when you change your username very strange.... maybe there's some wired security issue I'm not aware of.
But absent this.... really?.... stranding all of your old documents/games/videos/pictures if you decide to change your username.... makes zero sense.
==================
Edit:
I guess I'd actually first try renaming
C:\Users\YourNewUsername to
C:\Users\foo
then recreating
C:\Users\YourNewUsername
and then moving
C:\Users\YourOldUsername\*
to
C:\Users\YourNewUsername
That should absolutely work and moreover will take care of any unexpected references to things under the user name directory.
You might also need to fix security descriptors so that your new username account will have access to all the moved stuff... again, pretty easy if you've any experience with this sort of thing....
But yeah, for an average user, having to jump through all these hoops if you simply want to change your username is.... strange.