I have lusted after those. A Camry shouldn't be even in the same sentence, it's an insult to an 8-series. (Camry has its place, but in a very different mass market world).
The 8-series is still a beautiful shape, perfect coupe. With 5 spoke wheels they look gorgeous. (18" looks better I think, the 17" wheels look a bit too small for the shape, IMO. It's a pretty big car)
But the 850 maintenance costs would scare me. What about the 840, which has the v8? I assume maintenance costs would be less, overall, and easier to find.
Either model is hard to find with M/T.
I think 96/97 are the last and most sought after years. The ugly 4 spoke steering wheel was changed to a better looking 3 spoke one and A/T got Steptronic I think. Tail lights got a more modern look. Some electrical bugs were also ironed out in 96/97 models, but I have forgotten what they were.
When I was looking for a car I remember thinking of these, and also Lexus SC (Toyota Soarer) series that ended in 2001; (SC300/400); those are also great looking cars, even now, 1998+ best if you ever look for one (got a lot of interior and mechanical upgrades); Very nice interiors, too; Not much HP but I think they were quick enough for sure. Again I couldn't find anything low mileage.
(Finally settled for a 2005 330Ci E46 with the ZHP package).