Lot of franchises like that like the Cubs and the Lions in the NFL.
There aren't "lots" of franchises with a tortured history like the Red Sox.
They sold Babe Ruth to the MFY's, 1946, 1967, 1972 (lost the AL East by 1/2 game largely thanks to Luis Aparicio falling down rounding third base), 1974 (blew an 8 game lead to the LET'S GO O'S!!), 1975, 1978, 1986 and 2003.
They lost four WS in seven games, each loss more painful than the last.
The Cubs the most part were a broken toilet of a franchise, they had the longest streak between WS wins, but how many WS did they get to in that time? They are most famous for blowing the ALCS to the Padres in 1984 and Bartmann in 2003.
That's about it.
The Lions? They've never been to a Super Bowl, been to one NFCCG in their entire history and got demolished by the Redskins.
I'd compare the Red Sox to the Browns, famous for The Drive, The Fumble and Sipe throwing an INT in the End Zone vs the Raiders in the 1980 playoffs when all they needed was a FG to win the game.
Maybe the Bills and their four strait losses in the SB, or the Vikings, four SB losses, none of those games were even competitive, one of the greatest franchises that could never get over the hump. Throw the Capitals in there too, one nut punch loss in the playoffs after another until this year.
So, there aren't "lots."