A striker who was once one of European football's hottest goalscoring properties has seen his stock plummet in recent years