The lack of response to this thread seems to confirm that, save for typical idiotic reaction from the Polish media (zomgz great success in Europe!!11), nobody cares about this basically figurehead position.
No I do in fact think it's a great position, through I'm not sure it's better than being PM of Poland.
Of course the choice of Tusk also show that they have great respect for the man, as it's hard to imagine another person who didn't talk French or English, and was as headstrong as him being selected would be unthinkable, usual they select competent, multilingual wall flowers.
I agree this won't change the direction of EU's foreign policy one way or another.
While Presidency of the Council is, in theory, a powerful post, its pretty much become a ceremonial presiding officer, as evident with Van Rumpoy's tenure. All the President can really do is trying to play a consensul-builder, but it can work only if heads of governments play along.
Van Rumpoy have had significant influence as president, but most of it have been behind close doors, something which seem to fit well with him.
I think the position's power are based on the person which have it want to do with it, a weak stateman can get little out of it, a consensus seeking stateman can use it as a position as consensus builder (which was what we could have expected with Thorning). I look forward to see what Tusk bring to the position, my hope are that it will bring a much needed edge to the position.