Yeah the honda CVT modes are more related to responsiveness and rpm. It never holds itself at a single gear ratio when accelerating and constantly keeps varying gear ratios when accelerating in any mode. S and L mode just mean that it'll be varying at lower gear ratios to keep rpm high.
Toyota and Honda CVTs behave very differently. Honda CVT in city and civic x oriel acts like how a CVT is supposed to but in Toyotas there's a lot of emulation to make the CVT feel not like a CVT. New Hondas are moving to a more Toyota like CVT modes. Problem with that is, emulating gears makes CVTs lose their efficiency and performance advantages, but you don't even get the reliability of real auto transmissions.
A few months back I had a random friendly run with a civic X oriel on the motorway while I was driving a grande. Both cars were going dead even until the grande simulated a shift, and that happened in D mode, I wasn't in manual mode. Civic X easily started to pull ahead after cause at those speeds and at full throttle, civic X constantly stays at above 6k rpm and never simulates a shift to go below 6k rpm. That's the real advantage of CVTs which fake shifts remove.