I kind of sympathize. But I keep my eye on the ball, so to speak, not the miles, but what I can do with them. I need 300-400K a year minimum to fly my wife here (she lives in another city) and home to see her family in Europe every summer. And then... the trip we're taking togeher to Paris this summer, points for the 5-star hotel in Paris, telling her "You're flying business class to Europe this summer" or "Yes, I have enough points to fly your parents here business class anytime they decide they'd like to come." I have this RTW trip too that I'm hoping to take 3-5 years from now. Maybe someday I actually won't even need miles to fly her here sometime in a couple years! (I can only hope.)
There are the silly promos that in the fullness of time don't seem so silly. The Air Canada promo where my wife and I each got 16,500 points mostly for my eating a few times at disgusting restaurants and then converting those few miles to Air Canada miles one at a time on points.com - 33,000 almost useless miles until a friend called me and said "Redtop, I really need a ticket to Toronto" and wow, did I ever have some otherwise-useless points that I can turn into a future favor from him.
I don't keep spreadsheets. If I can't do it in my head, it's gone too far. But yes, I get itchy, sometimes I think "OMG I only got 12,000 points this week, what am I doing wrong?"