The most important things to have are manual settings for iso and shutter speed.
Next is to have a big sensor.

To get good pictures you need to turn the iso down as much as possible and increase the shutter speed to whatever setting makes the image look like what you see irl. Usually several seconds. To avoid blur you need to put the camera on a tripod and use either an external trigger or the timer. Most cheap cameras have a timer, but only high end ones will have external trigger.