A bus/train cannot reasonably serve a cul-de-sac. The time needed to get down it and back is robbed from everyone who wants to go elsewhere. There is almost no destinations at the end - even if it has one (as it is in the case of many large office complexs or hospitals), not enough people are going there to be worth the time stolen from everyone else.
If you want good transit you need to be on the way to someplace else. That applies to both your start and destination.