First - I'll say that I vote to close when I am fairly sure that I can't edit a question to the point of useful-asnwer generation without either obliterating or massively changing the original question's intent. That leads to two typical cases:
1- the intent is unclear - the question is so poorly written, or it is so obscured by other text that I really can't find it.
2 - the intent runs directly counter to our FAQ - so if I edit it to fit our mission, I will generate a question that doesn't serve the poster's obvious purpose.
Your question has a bit of both.
First tip - clarity in asking
When @jmort253 says to "Edit it down to a paragraph or two", he means to spend approximately 1 paragraph telling us why you are asking and what hasn't worked in the past. Reading your backstory, for example, I'm left with the thought that it's both unique to you and that there's nothing there that will help me give you advice to fix the problem. This can get pretty tricky in The Workplace - a programmer's history of past actions and results can often set the scene very clearly for next steps in problem solving. In The Workplace, the list of trials and failures can read more like a personal soap opera that has little relevance to moving forward. I'm afraid this one of those cases.
Similarly - your motivations are your motivations. They are nice enough, but it'll be hard to give you an answer that is specific enough to help you while being generic enough to be part of an site that other people will find useful. It leads me down the path (as the reader) of thinking you want help finding a job, not help understanding theories of motivation.
Lastly - sticking questions in the middle of the post is almost universally hard for readers. Figure that people will scan the post quickly and they will expect the most important information to be at the beginning or the end. If they have to read the entire post (in depth) to find what you are asking, they will start getting frustrated.
Second tip - find the general question
In this case, I'd suggest putting yourself in the place of a person with a wildly different background and work history and seeing if there's a common question you would both get value from.
Given that you found use in pap's comment might be a clue - his link relates to theories on motivation in the workplace. So another question on how to connect theories of motivation to job searching, or how to employ common motivation strategies to becoming "self-managing" might be another.
You're in a tricky area - not everyone is motivated by the same thing. There is a wide variety of motivation theories, and they don't apply equally to all scenarios. Also most theories take into the account that each person is different, but most offer a way to figure out a general type of person and ponder how that type might be motivated. From there they all break down... so saying "how can I, specifically, be motivated?" is a lot like asking for specific career advice - to answer it for the entire community, there'd have to be a unique answer for each individual. And to try to generalize the need to be motivated may be impossible - because the very thing that motivates you may de-motivate someone else.
So particularly in this area, a big, highly personal, backstory will lead people down the path of thinking you want particular career building advice. If you're looking for bigger picture models, or a process for matching motivation to personality or maybe even typical corporate approaches in a given field to how they expect to motivate employees - that might go over better, but to be honest, this IS a rough area.
There's also the vague possibility that you may be asking for more out of your field than it can provide - the list of motivational things you mention don't immediately align to many Computer Science jobs - I'm not saying it's impossible, but your listing is incredibly people-driven while the majority of the work for people in computer science is fact/problem/puzzle driven - I'm not saying extroverts can't work in this field (that would be hypocritical of me!) but that having 3 out of 4 of your motivational factors be people-dependant, and then the 4th being very unstructured forms of creativity--- it sounds initially like a tough match where you may well consider a career counselor instead of this site as your best path to a solution.