I think getting a random weakness at the beginning of the campaign and keeping the same one throughout the campaign would be the most logical.
To add to this, I think you will be adding weaknesses in between acts based on the horror still on your investigator