"Better" is a malleable term. Better for what? Fuel economy? Power? Fun?
"S" mode on the civics doesn't do anything to the suspension. All it does is change the gear mapping for the transmission to allow the car to stay in peak torque area. It's not nearly advanced enough to change things like the suspension feel or steering feel. It's just a change in throttle response.I recently drove from Michigan to South in EXL Civic and I will say it pepped up when driven in sport mode. The suspension tightens up and handles mountains much better. Drive mode spins the wheels faster but handles a bit loose. Sport mode uses more gas.