Many effects could be faked with digital but I have recently gone on a bit of a film binge and ill discuss what I have found, hopefully it will shed some light on what you are looking for. If you have played extensively with photoshop and digital and find its just not giving you what you are looking for, film may be your solution but there are some things to keep in mind.
For a long time film was physically superior to digital and was part of the reason it was considered "better". We live in an age of fast moving tech and as such
digital has caught up to film (mainly 35mm) quality and gone bast it in some regards. As such getting out an old 35mm camera will give you the colors of old film and the feel of an old camera but it wont really make different pictures (from a more objective standpoint) than a DSLR can grab now (assuming you have a modern DSLR). Form the work I have done I can generally recreate the feel with digital.
The Hasselblad and Medium Format:
First off, if you really want a Hasselblad they have really come down in price. While they are still expensive they can be had for fair rates. I just picked up a 500CM in a gear trade for a pretty fair deal.
Ebay is a bad indicator of them as many are just over priced By It Now auctions. They are out there, and even a broken one can still be fixed.
David Odess still services them if you happen to get a good deal on a broken one. While the Hasselblad is a great camera (perhaps the best by some reports) it is also
medium format (120 film) which has a very different look than 35mm. A lot of this has to do with the fact that the negative is physically larger and thus will yield an image that is somewhat different looking. That being said there are plenty of
medium format digital cameras out there and I think all to often medium format film gets compared to full frame digital which is hard to make a fair comparison on.
You dont need a Hasselbald to break into medium format, there are lots of other options out there for really great 120 cameras. The Rollei stuff can be had for a bit less than the Hasselblad systems and will yield great results. You can pick up something like a
Mamiya 645 for a pretty fair price or if you want that hassie look you can get a Kiev-88 but those are a bit dicy on quality control. Shooting medium format wont give you album covers every slide, it may help you to create a certain effect but you control what gets photographed.
But most importantly of all
your camera does not matter...