I don't think I posted this video on my blog yet, but this is how I take my photos for the blog...
When taking makeup photos I generally (though not always) use the same camera I use to record my videos, a Sony Cybershot DSC-T2.
Here's some decent articles I found that you may be interested in:
Getting a good exposure
Deviant Art is a great art community where you can store your work, AND it has TONS of resources. Check it out!