Star Trek: Deep Space Nine: Season 6, Episode 13

6 - 13: Far Beyond the Stars

After a friend's ship is destroyed by the Dominion, a despondent Sisko contemplates resigning from Starfleet while experiencing visions of himself and his crew as sci-fi writers in 1950s America.