One of the original creators behind The Elder Scrolls has died after being diagnosed with terminal cancer