Yes. But you need to know how to compose and control, if possible, the lighting. But then that's the same with any sort of camera.
But please understand, the stunning photos you usually see are the result of starting with a good image and then processing it through photoshop or an equivalent.
I pretty much refuse to use a photo editing program except for cropping or resizing. But I'm old school. I still pay attention to composing the image and setting the camera settings correctly. The one advantage, and the only one in my opinion, that digital has over film is the ability to take many more photos without any expenditure of money.
I particularly like this photo. It involved well over two hours getting to where I wanted to be with regard to the duck. Then setting the camera correctly.
Still got busted though.