Yes, many anime works had plots where the male lead was useless at first and then became strong. The more famous ones included Naruto, One Piece, Hunter, and so on. The protagonists of these works often had some flaws and weaknesses at the beginning, but as the plot developed, they gradually gained great strength and ability to become true heroes.