I've had my Hornet for going on 4 years now and still think that it's a great all-rounder.
She handles well in pretty much any weather, although I have had her get a bit twitchy in really severe rain. That said, she's always been very forgiving, even on those rare 'torrential rain' occasions and I've never felt out of my depth on her. That reasonably forgiving nature not withstanding, when she's asked to, she goes like a greased gazelle up a drain pipe and simply exudes grin factor!
Taking her out on a Sunday morning in the sunshine or just heading to work or town on her is a pleasure and she's comfortable over longer distances too.
The only tricky aspect of taking her over any distance, especially if I'm going to be staying a few days, is load carrying. I don't do those sorts of journeys often enough to warrant hard luggage, and managing to get her loaded up safely can be a bit of an onerous task. That said, once it's all done, she's still fairly comfortable, even if I'm taking a pillion as well.
In short, I think the CB600 Hornet is a pretty great machine that's reliable and fun. I'd also recommend it as a first bike due to her reasonable comfort and fairly forgiving handling should one make a minor faux pas.