For the hard-core enthusiast the new Si may be fine. But for someone in the snow belt the softer riding Sport Touring HB or Sport HB with a manual will be almost as much fun and a better daily. And all of them handle well.
A lot of reviewers have mentioned the new Si's firm ride and no adaptive dampers. And they were driving on smooth California roads.
I'm going to wait for the Integra.
From looking at the owner's manual, I am guessing you can change the steering or gauges to Sport in Individual mode without the added sound but if you select Engine Sport you get the added sound.
Maybe test drive the Sport hatchback 2.0 NA manual. Many more color choices. Neither manual Civic is fast. The Sport may be fast enough for you.
I probably won't buy an Si because I want silver. Will wait to see Integra color options.
Color is a big deal to me.