I use a pentax DSLR, but I'm a camera snob
I've always used an slr camera, and when I went digital, I just picked up a digital body for my collection of lenses.
I use manual focus if I"m taking pics on a gaming table at a tourney (tends to be a lot of 'desert tables' and a lack of contrast around here) and auto-focus tends to not work well.
My wife has a compact digital, and I've also used it ( but the controls are in odd positions for me - used to the dial and thumb controls being on the right side around the grip) to get some decent shots.
In addition to a camera with a decent macro setting, a stable platform (tripod or bean bag) and lighting are required for good shots. You can take great shots with a entry level camera if you know what you are doing, but if you don't, not even a top range pro-level DSLR will help.