Ever heard of Alex Majoli? Have a read at the following article:
The equipment plays a part... but the photographer makes the picture! I've seen pictures taken from phone cameras that are fantastic! I've got a friend that uses a simple compact digital camera but produces great pics.
Every equipment has its limitations... even 40D, D200, etc. Know what the limitations are, and work around them to get great pics.