I have recently added an extra 1gb of RAM to make my total RAM up to
3gb. However, the Windows Experience Index score for RAM stayed at 4.1.
Is there any reason for this or is it just Vista being stupid again?

The index rates the RAM's speed, not its quantity.

My view is that what the index mostly does is confuse people, and it
would have been better if it weren't there at all.