Any goals I set regarding a particular weight would just be arbitrary. Squatting 1 1/2 x BW or DL 2X BW just sounds cool to me. There's nothing particularly special about 260 or 340 pounds, but I think it would be fun to do those some day. If I don't my life won't be a failure. I don't know at this point what I'd say my goals are for all the major lifts. I'll come up with more specifics in the next few days. I agree with having both long-term and short-term goals.
My main short-term lifting goal at the moment is to gain some ground on Peter in face-pulls while he's hurt!
More important are my functional goals. I don't really have any specific strength requirements for my work or recreation, but there are some things is daily life that lifting helps with. At this point most of these are already pretty much in place, so the goals are really to maintain things.
To keep my weight at a reasonably healthy level for the rest of my life. I think that's under 175 or 180 pounds, although as we have discussed on other threads there's no clear way to define that. I'd like to see what it's like to have my weight around 160 for a few months--I may revise the goal! Lifting is an integral part of my weight control.
To keep my arthritis under control. My arthritis bothers me much less when I exercise regularly than when I don't. Right now I'm only takeing glucosamine and costochondroitin for it, and it's not bothering at all. (I had surgery for the arthritis in my right knee about 3 years ago.)
To have good posture and to be able to move easily and freely and without pain or stiffness in daily activities. Other than when I hurt myself and make everything worse, lifting really has allowed me to feel and function better in all parts of my life. I have a ways to go on this one.