I think it depends on what you're trying to achieve. My personal stance is to go as free (as in liberties, or
libre) as possible unless you have a reason or personal preference not to. For myself, for software that means the
MIT license unless something mandates a more restrictive license. I haven't published text, but I think I would publish CC-BY-NC-SA and entertain other CC variations or other licenses depending on what I was hoping to achieve.
Just because you publish something under a CC license, doesn't mean you can't grant someone else a different license. For example, you could publish a book electronically under CC-BY-NC-SA and then grant written permission for a publisher to do what is necessary to publish, distribute, market, and sell the paper book.