Occupying listed buildings can be awkward and costly, but do the frequently impressive results justify the expense? John Ryan reports