A lot depends on what you want to do with it. For taking product shots on eBay, a little distortion and chromatic aberration isn't really going to matter. A shallow depth-of-field is a nice look—and a weakness for P&S or typical zoom lenses—but you usually want your product shots sharp so people can see everything anyway.
If you plan on doing portraits or fine-art work, then yeah, a DSLR with some nice prime (non-zoom) glass is the way to go. Or spend the $$$ on a big aperture zoom.
This article is five years old, but I think has a decent comparison.
A lot really comes down to knowing how to use the camera and photo editing software. Just adjusting your black and white points properly will pop the contrast and be a big improvement over an image straight out of the camera. People often get into the trap of trying to improve their images by spending money on equipment when really a few classes would be a better investment. I know you are looking for a new camera anyway, but I wouldn't expect to see any real difference in the images, no matter how much you spend.
A friend of mine has shot for Life, National Geographic, etc., and given his choice, he goes for the cheap toy cameras like the Holga.