I wouldn't call the German president completely powerless. They can veto laws that seem unconstitutional (and this was done multiple times in the past). In case of war they play an important role. Their speeches often have large Impact.

But compared to other countries that's still relatively few powers.