Why use miles to upgrade when you can get a virtually unlimited supply of upgrade certificates (Air Canada Aeroplan as Super Elite)?
Just kidding, while I do enjoy the unlimited upgrades on Air Canada, I actually enrolled in LH Miles and More program for the possibility to use their miles for upgrades for travel from Africa to Europe.
Now I wish I had miles in my SQ KrisFlyer account so I could upgrade my SIN-JNB trip next month. 10 hours in the back is not life threatening (oh wait a minute, it can be with DVT) but sitting up in business or first gives me a much more pleasant disposition.
I think that everyone has hit the main points. It is how you value the miles. I have redeemed almost 4 million FF miles and now wish that I had done more of the long hauls in business or first. I used to think that 100,000 miles was a lot of miles but not any more. They just seem to keep coming at 400-500,000/year.