I, too, am a messy person!
I use sleepless nights to clean my sewing room. After an hour or so of tidying, the room is ready to use again, and I'm ready to go back to bed.
I keep my fabrics in Rubbermaid plastic storage boxes, sorted by color (and labeled), stored on bookshelves. This enables me to pull out a box, select what I want, and then put the (still tidy!) box back on the shelf. Of course, periodically you need to put all those "selections" back where they belong!
Unfinished projects are stored either in more plastic boxes or in large ziploc bags in a drawer (depending on size). I sometimes use cardboard boxes, but then the "out-of-sight, out-of-mind" thing kicks in. Long-term UFO's are banished to the closet......
Projects I'm working on are generally festooned about the room, but I try to fold fabric and clear the cutting table after each session so I can start again another day without a shovel.
As far as the rest of the house goes, I have a cleaning service that comes in once a week. I HAVE to pick up so they can clean, so this forces me to make at least a weekly run-thru and keeps disaster at bay. It is well worth the cost to me.
Good luck!