To me, it's not a matter of "sport bike vs Spyder". (By the way, your Connie is not exactly a "sport bike".) It doesn't really matter if you have a sport bike, cruiser, tourer, adventure, ... whatever, it's more about 2 wheels vs 3 wheels.
I am more into the touring scene, so the sportiest bike I have had is my (current) '80 Suzuki GS850G, which is fully-outfitted with fairing, saddlebags and trunk, along with a bunch of other farkles.
My wife is the one that recently got the Spyder in our family. I have had a fair bit of time on it, so am reasonably comfortable with it, but I'm not quite ready to get one of my own. For the last 15 years or so, we have very seldom ridden two-up. I have had my bike, she has had hers, when we go on a vacation ride, two vehicles are headed out, not one.
Where are you in oHIo? If you are in the southwest part, stop on by, take a test ride, we can chat for a while about it.
.