There are some differences, but between the CE to LE, there is not a lot of easy 'meets the eye' stuff.
CE and LE differences for 1997 minor. Interior seats were different materials and there was no shift light indicator on the dash cluster. A lot of options (power locks, windows, keyless entry) were not standard (was the keyless entry factory or aftermarket?). CE trim in 1997 had a physical antenna in the back trunk that no other trim (or years) after had. CE trim also had no option for ABS as well IIRC except with V6
As for the 2007 models, I don't recall much difference. I consider the 'CE' trim a strip down 'LE' trim with the LE coming with more standard options and optional package. Probably the CE doesn't have power seats and keyless entry. Check for lumber support as well, may not have that.
To be honest, the CE trims never sold well (standard trim) since most people wanted/considered the power windows, locks, and key fob entry a 'must have thing' nowadays. Since most people wanted those features, they would add it on, but to get an LE with those added on for a small amount more, LE sold more.