I confess I have a number of TLRs -- they're just too cheap and retro (rather like rangefinders!) to resist. Most recently I have acquired a couple of Mamiyas, the C220 and C330f, though haven't run film through them yet. These are both rather massive cameras, the 330 especially, so they might be a little better suited for tripod use. The interchangeable lenses and macro capabilities make the Mamiyas by far the most versatile of the various TLRs. They're also the easiest to load, since the flat back swings straight down -- no L-shaped back (which contributes to curling the film if it's been sitting in the camera for any length of time). If the camera's on a tripod, you don't have to dismount it to reload, which is great.
I haven't read through this whole thread, but I wanted to put in a special word for a couple of lesser known but excellent TLRs -- the Ricoh Diacord and the Kalloflex. Both have fine Tessar-type lenses. The Ricoh (which is not to be confused with the Ricohflex) has maybe the best focusing mechanism of any TLR -- levers on either side of the lens standard that are diagonally opposed, so you can, essentially, hold the camera with both hands while using your thumbs to focus. Very convenient. Knob wind.
The Kalloflex is a most impressive (and relatively rare) beast -- more substantial than any TLR but the Mamiyas, and beautifully made. Lever wind on the right side (as you hold it) that's on the same axis as the focus knob, which makes for quick handling.
Nick (whose current stable includes Kalloflexes (2); Diacords (2); Mamiya 220 and 330f; Yashicamat 124G; Rolleicord V and Vb; Rolleiflex MX-EVS; Autocord CDS III and Type IV). Oh yes -- a 127 Primo Jr. (cute!)