Does 9th hitter in baseball mean something special?

I know the fourth player in the batting order is known as the cleanup hitter, also known as the cleanup spot and in modern baseball is almost always one of the best hitters on the team.

At about 1′13″ into the video linked below, the announcer says

that’s a pretty good number nine hitter

Does 9th hitter in baseball mean something special? The link starts at 1′8″.