Creative people: what career do you have that actually allows you to be happy?

What about the many "mediocre" creative heads, like me, who aren't good enough at art to make a living of it, but just end up suffering in any normal job they try? Who are bad at math and related sciences, hate working with people (at least I hated customer support) and going to an office, and can't STAND being bored?
How can they have a career AND be happy? Is it key to just NOT work full-time so that your job doesn't kill your soul, and accept being poor?

I've become so disillusioned with the search for a career. Almost 30 and still lost, feeling like there is no chance in hell that I can ever be happy as long as I have to work? I feel like I can do almost anything for 3 months, but then it becomes torture/boring. 40 hour weeks make life seem meaningless. I never want to be tied to a location anymore, hate big cities and commuting. I studied hard for my degree in geography, thought I would find fulfilling work that helps the environment, but could never land a job because I don't know GIS. The best idea I had so far was freelance writing, but that also turned sour.

I know many creative people must feel like me. Am I asking for too much, do I just have to bite the bullet and suffer? Isn't there anything that has worked for you in the long-term?