I wouldn't mind a thread necro warning (e.g. replace the "Submit Reply" button with a 300x200 pixel green and black skull image), but I've revived my own threads after a while to post updates (e.g. achieved higher overclock).
Other places auto-locking may not work nicely would be the WIP (I can't recall the exact one but I saw a worklog where the OP posted an update 1 year after their last update.)
My current favourite of "necro'd" thread, revived to great effect after about three years:
Horrible pictures of dead caps