Hasselblads are great, so are C330's not to mention Rollei's and many, many others. I'd shop for a 500 C/M rather than a 500C, mostly because the 500 C's are pretty old now, and there is little price differential to get to a C/M.
Hasselblads are a relatively expensive way to get into MF, but the optics are wonderful, they are great to work with, and if one fits your budget, why not?
Lot's of folks prefer TLR's because they are quieter, you don't contend with your view finder blocked when the shutter trips, and as you acknowledged, they are much simpler.
I've used/owned Hasselblads, C330's, Rollei's, a few others.
Between Rollei and Hasselblad, I may get shot for saying this, but I think they are a bit of a toss-up. On the Rollei side, you get simplicity, more flexibility in viewing without a prism, fixed lenses, no interchangeable backs. On the Hasselblad, you get interchangeable lenses and backs, more complexity and a little less cost of you want a 2.8 Planar lens. On either, you must resort to close up filters, or extension tubes (Hasselblad) to focus closer than about 3 feet.
The great thing about the Mamiyas mentioned so far, is that they have a bellows and focus very closely. On the 330 you contend with parallax, but that's not a huge problem, it has correction built-in that will be fine for moderately close working. It's major downside, as a TLR is the size and weight. They are't quite as refined as the German cameras, but are reliable, and do what they need to do, which is give you excellent images.
Good candidates if you want to get in a bit cheaper are Rollei SLR's, Bronica's, German Folders, f 3.5 Rollei TLR's, and lots of others, that I'm sure will get a mention.
Barry