Loser Lover
The lovable loser is a character archetype portrayed as a sympathetic, likable, or well-meaning person for whom bad luck continually prevents their various efforts from succeeding, and from obtaining the things they feel will bring them happiness particularly an idealized true love.