Mamiya C 330
This is a fun twinlens medium-format camera with the unique feature of interchangeable lenses.
You can get one of these fairly cheap and you'd be suprised how good the quality of the cameras is.
You can focus extremly closely and take real makro-shots with a standard lens, see some images under 'Impressionism'.

See full manual and specifications on this superb page (external link) were the image is also taken from.

Some comments on Mamiya C 330:

• This is also a product i sometimes miss and remember with great respect, some of my best shots was taken with this pearl of a medium format camera.
• 
  For anyone who want to get serious about Photography and are on a budget; buy this one(i had The C220) and you will be amazed about your prints and the quality youll get!a very fine systemcamera and highly appreciated among many people.
• 
  Excellent camera to move up to Medium format. Mine is a C330s, the latest and it has never failed me. I can recomend it to anyone who's willing to take good pictures and excercise his biceps at the same time ;-)