Its mostly happened to me in online games, I have a folder of them on my laptop.
In Local games, I have a few stranded characters, but I dont really miss them. The games were obviously failing, and a fun Character in a bad game only lasts so long.
I mostly run games, and a short campaign is six months. The only one I felt was stranded was due to player changes, 1-4 sessions before the showdown with the BBEG. This was the long arc guy who had destroyed a town which was the basis of the first game. The players gone 2nd-9th level, had fought him once already, and were in the midst of laying a trap for him, when the game lost 1/2 the players. Two others ended after finishing the first long arc.