Yes, it basically all comes from what I don't want to do and then just rephrased to be more positive. Take my desire for a mentor or creative coworkers. I work upstairs in the tech department even though I'm doing video editing, graphic design, web design, frontend coding. Why am I surrounded by soldering irons and audio chips and broken batteries and engineers? Because management doesn't know what they do either so they hide us all away up here. No one knows what I do. I take care of every department (web, marketing, production, tech, sales) but they don't understand the skills I have. They just know I'll get it done. The problem is getting it done doesn't help me grow or get better. I can deliver an ugly ass powerpoint or a gorgeous one and they won't know the difference. It makes it hard to deliver something worthwhile when you don't have any expectation or feedback. I know when things don't work, but don't know how to fix them. Sometime's I'll disappear for an hour and go grab drinks with some old shithead friends of mine in order to have some sort of brainstorming atmosphere for whatever task is at hand. When drinking with unemployed drunks at noon in a dive bar is a better creative atmosphere than your office, that's a problem. So yeah. That's pretty much how I get my desires. As for the deleting drunk tweets. My goodness, I know that feeling all too well. I have a video still floating around of me freshman year of college, drunk, just talking about my cool lighter. I'm massively drunkenly adorable but still. That slight shame that you feel after a drunken night is natural. If it happens too much or your sober self esteem starts being affected then maybe it's time to take a closer look. But being goofy or saying silly stupid things is fun and it's real. I totally get the desire to have someone share that with you. Your SO should be experiencing that same shame with you, not looking at you from the outside. I like that a lot.
I was going to reply to your original comment since I feel much the same way, but this statement here is particularly helpful. I often feel lost, like I'm spinning without direction and find myself unsure what I want out of life. At those time it's much easier for me to identify what I don't want, than what I do. From there I can narrow things down a bit. This takes some time however, as it requires thinking, reflection and experimentation but a path, or at least a direction, usually surfaces.Yes, it basically all comes from what I don't want to do and then just rephrased to be more positive.
You just have to restructure your thinking to be optimistic and happy. People like that shit. I would bitch and moan all day if I could but it's much more fun to pretend you have your shit together, have everything under control and all is fine and dandy. Plus sometimes it tricks yourself into thinking you actually do have your shit together when you're really flailing.
This reminds me of the maxim "The best way to be happy is to simply decide to be happy" While initially this was confusing and nonsensical to me I've found it to be more or less true. Perspective plays a large role in how we approach and feel about things.