I had a low mileage garage queen '96 for a while back that I used as a daily driver for a few years. Not a scratch on it to be found. Even having low mileage, during the course I had to replace all the wheel bearings, axle u-joints, tie rods, fuel pump, driver seat track and motor, a few hoses,and a few other things that didnt seem like they should have been worn out yet. Nothing major or horribly expensive though. Maybe she had been beat on in her earlier life, didnt look like it at all though. After a while the 4L60e developed an inconsistent and very clunky 2-3 shift that seemed common enough that almost everybody had heard of it, but uncommon enough that nobody seemed to have a consistent answer as to what was causing it or how to fix it, other than wanting to tear it down piece by piece to go exploring for a cause. I just learned to try to ignore it. I've been in and out of a few JATCO transmissions over the years and know how to tweak some of them, but GM boxes are out of my league.
The whole car drove nice enough I guess, and it was a lot more solid (at least with the glass roof on) than I expected it to be, but having driven C3's a few times my expectations for a C4 were horrifically low to begin with so that might not be saying much. With the removable glass top removed, the whole body became a loosey goose squeaky heap of fiberglass and leather with the structural integrity of a overcooked lasagna noodle with tires on it, so unless the weather was super nice, the glass top stayed on. Got really good MPG. It had lots of torque, it was shiny, and it made some beautiful sounds. Getting in and out was a chore that didnt bother me at first, but it got old quick, but once you were in, it was pretty comfortable. Tires were expensive. Didnt corner or stop nearly as well as my worn out 240sx did or even currently does (or at least seems to) which really, really surprised me. Maybe that was just a perception, but I can say I have thrown my 240 into some corners at speeds I would never ever again thrown the C4 into out of fear of swapping the front and back ends in a hurry, which I shamefully admit I did more than once. The whole car just felt bigger, wider, heavier and bulkier than it really is.... or maybe it really was. I dont know. Anyway, my friend pulled up in her C5 a few months after I got my '96 and after she let me drive it around for a bit I instantly regretted my purchase. The C5 felt better in every way possible, and if I had listened to just about everyone and bought one of those instead, I'd probably still have it.
If I inherited a C4 that had some life in it, or I had time to tinker with it, I'd gladly take it. But I would never shell out money to buy one again.