The above photo was taken with my Canon 7D, which is a fairly expensive DSLR camera used by many professional photographers. I used a tripod and 5 different exposures (combined). It is a wonderful fall scene.
The below photo was taken with my Canon G12, a point and shoot camera. It is relatively sophisticated, but a point and shoot nonetheless. I did not use a tripod and I popped the on-camera flash to brighten up the foreground.
The quality of the G12 photo is not as good as my 7d (phew), but you can see that you do not have to have a “nice” expensive camera in order to take a wonderful photo. You just need to know a little bit about good composition and light. Try it.