Welcome Luna! The Connie is a beast, isn't it? I have one now, had one ten years ago, with an ex500 sandwiched in between. I think the only thing you're going to miss is the power and the sound, but honestly, an ex500 in good condition, properly maintained, is no slouch in the performance department. It IS a lot like the Connie, but it's much lighter, easier to live with, and doesn't bake you in warm weather.
It's a really versatile, fun bike. There's been many a time I wish I had it back. I think you'll love it.