For in-studio (or home-studio) I would recommend a dSLR (one of the newer Nikon/Canon) with (for example) a 100mm macro lens, some good lights, a product bench, and good post processing software. Not to say that that set-up is required, but it's what I am familiar with and what I would use...
For field work, my choice would be a camera with manual controls, an appropriate lens based on the camera body selected (or in combination if a fixed lens solution), and some off camera lighting. Again, a personal preference...
Obviously the D Lux is quite popular with the team here, no reason to dis that solution as the results speak for themselves. Changing gear for gear sake is not a reasonable approach....
Having said that, I would be comfortable recommending a hands-on look at the "Q". It's an impressive camera solution, that feels great to use.
Casey