Extremely reliable and very comfortable. I've had it since brand new (5 miles) in May 1997. Change oil every 3000 miles. Flush transmission every 15,000. Both a bit of overkill, but a whole lot cheaper than expensive repairs and no real down time.
On this model you have to change timing belt every 60,000 miles. I think in '98 or '99 they switched belts, which require you to change every 90,000 miles. Something to consider if buying a used Camry 4 cylinder. (same body style 1997 - 2001)
I drive mostly around town, but drive from San Francisco bay area to Texas and find car EXTREMELY comfortable. I drive for many hours and get out feeling fit. On highway at 70 mph with A/C on I average just under 33mpg (and it does NOT burn oil). Message is: Spend a few bucks on maintenance and you'll be a happy camper for many miles to come.
Trunk is very adequate, if not large for a vehicle of this size.
I have owned many other vehicles. My family and I have owned 6 Toyotas (Corolla 3, Camry 2, 4Runner 1). They were all excellent. Next car: I will go only to a Toyota dealer.