I released Turing Evolved and Military Diorama under CC, BY-NC-ND license.
It's important to note though that I actually want people to copy and redistribute it for free and I even encourage fan-fiction so there's no question that as long as it's non-commercial, that kind of stuff is OK.
If it became hugely popular, great, then maybe a publisher or agent might notice me
Might even seek print rights.
I have moved over 10,000 copies through the year and have no regrets. I just feed the license in at the top of the book and discuss it at the end.
As a kid, I really enjoyed shareware. A lot of the games we have today evolved from that scene. I'd like to think that writers of the future may similarly evolved - that you find a publisher and agent not by sending magazines into the slushpile but by proving yourself on a self-published book first. I have no idea if that idea is crazy or not.
But I have never regretted publishing under a CC license.
Regards
David