I have the same ambivalence as a writer. The ideas are there. The motivation isn't. I can write something funny and it comes as easily as breathing. Mysteries and romance, not so much. What once came effortlessly is now a daily struggle. Eventually, I'll finish something.
I hate doing promotion and marketing, though. That's one of the few things I miss about traditional publishing--they did all of that for me. I refuse to do it now, even if it means lower sales. No offense to my fellow authors, but I'm pretty sure I'm not the only one who finds the tsunami of Buy My Book posts on social media annoying. There's promotion, and then there's taking it way too far. Authors are fast replacing proud new parents and grandparents armed with baby photos as the people everyone goes out of their way to avoid. (Have any of you ever seen the episode of I Love Lucy in which Lucy and Ricky are at odds with Fred and Ethel over Ricky's nightly showings of his home movies? I don't want people throwing rocks at me.)
I know self-promotion is a necessary evil for authors trying to build their careers, whether they're self, indie or traditionally published (unless, in the latter case, they're lucky enough to be in one of the top spots on a Big Five publisher's list and the recipient of a portion of their publisher's promotional budget). It's not easy. I've known talented authors who would rather give up writing than have to do their own marketing. Some of them actually have.
Whatever happened to word-of-mouth being the best sales tool? I guess I'll find out....