"What does everyone think of them? Reliability, handling, rarity, most common failures, fuel mileage?"
The 600 is all of the above, but just not reliable. By V12 standards they are not bad to own... If you are cross shoping one with an older Ferrari or Lambo.
But if it isn't your only car and more of a toy car I would go with the 12, it is one sweet motor.