Macro work would be nice, but what I was really aiming for is architectural work, because I do a lot of cityscape and street photography. So I guess I can forget about that, without a proper view camera, right?
Not necessarily, you can do tilts and shifts on any format, really, depending on what's available. But for architecture you definitely need something that can focus to infinity, any Hasselblad lens on any sort of adapter to a Hasselblad body will be macro-only.
There are adapters to go between formats, eg you can use Pentacon/Kiev/Hassy lenses on 35mm with a cheap Ukrainian tilt-shift adapter, 6x6 lenses on 645 or 645 lenses on 35mm are also possible, but Mirex and Zörk adapters are expensive.
I'm not sure what can be adapted to a Hassy body (I know Pentax 67 can't work on Pentacon 6 because of a long pin, I'll presume Hassy is the same), but anything that could would have to be leaf-shutter unless you've got a 2000 body.
Some formats (like Canon EF) have dedicated tilt/shift lenses, a lot of others have shift only (or like Mamiya RB/RZ, a shift-lens on a tilting-focussing body gives both tilt and shift together).
From what I know (although I'm happy to be corrected), there are no dedicated shift-lenses for Hasselblad,except Hartblei Superrotators (good luck getting one under $600 for old-style, $1200 for new Zeiss co-branded).
So you're probably going to be stuck changing formats anyway. You could go down to 645, with Pentax 67 lenses on a $3-500 Mirex/Zörk adapter, go Mamiya RB/RZ with shift-lens on tilt-body, and Fuji GX680s are surprisingly cheap for what they are. But 4x5 bodies are mostly cheaper by comparison, get a rollfilm back and you're good to go.