Calalily, I don't quite fit your requirements, but I'd really like to give it a try. I've been fooling around with CC creation since the Sims 1, but nothing's ever come of it. I'd like to perhaps finish
something before the Sims 3 comes out.
I fooled around a little bit with moving vertexes in the Sims 1 days (but never actually made anything), and I attempted to make a cat statue a couple years back, but I wouldn't be able to do mesh anything without a tutorial. I really don't have any bloody clue.
I can't find my little statue, or else I would show you guys. I wanted it to raise a stat a little when a sim viewed it, but I couldn't get that to actually [i[work[/i], so I gave up. :/
More recently, I wanted to make a custom pet magazine rack (not just a recolour) with pet magazines. I got as far as cloning the object and extracting the textures when I realised I had ot no clue as to how to go about making custom magazines, and gave up.
I think I need to stop having such big ideas, and take baby steps first.
A little hand holding might help, too.
What I would also find useful, if anyone is capable and willing, would be a texturing tutorial, particularly for clothing. Not one that teaches how to paste on graphics and trace over shadows, but with hints and tips for texurting for people who are not complete Photoshop noobs. One thing I find really frustrating is getting the texture to match at the seams.
Painting a texture for a 3D model is a lot different from a flat picture, and it would be great if something could be written coming from that angle.