In yesterday's Thought Of The Day I listed several links to examples of great photographs taken with cell-phone cameras. I think, more than anything, it shows that any camera--yes, any camera--is capable of taking great photographs when in the hand of a skilled photographer.
You don't have to spend thousands of dollars on high-end photographic equipment. You can spend that kind of money if you have it and you want to do so. However, great photographs can be made with a $150 camera, with a $50 camera, a $20 camera, a $5 camera and a free camera. Perhaps that expensive equipment will make it a bit easier to create a great photograph (and sometimes it might make it harder), but any camera is capable of creating great photographs as long as the photographer is, as well.
And if the photographer is not capable of creating great photographs, no matter how expensive the camera is, it will not be capable.
As Ansel Adams said, "The single most important component of a camera is the 12 inches behind it."
The best advice I can give right now is to use the camera equipment that you have right now. Don't get caught up in thinking you need this or that to make successful photographs. Instead of spending money and time looking for new equipment, learn how to become a better photographer.