Now, believe it or not, I used to have one of these.
I bought my Hornet 900 not long after they first came out so I paid full whack. Then about 3 months after Honda dropped the price. But they've never been a big seller and so you can pick them up quite cheap for what they are......and they are a very good naked bike.
Personally I much prefer naked bikes because they keep you from doing 'go to prison' speeds. Don't get me wrong, the Hornet will fly and they are great fun to ride....just don't expect to do 150 +. (which, in this day and age of speed cameras and vans, is probably a good idea).
The bikes are pretty much bullet proof with the engine taken from a well tested source. It's a Honda so build quality is good EXCEPT for the heel plates which used to rust on all the Hornet 9s. They are plenty fast enough on the type of roads I like to ride on, smaller A roads and B roads where the fun is in cornering and overtaking and not flat out speed. They are well capable for two up riding. i used Macadam tyres which proved to be brill, chains last about the norm...12000, servicing is reasonable but is every 4000.
The only detrimental aspect of the bike was that the suspension could have been better. Its ok and capable as standard but if mine hadn't been written off I'd have gone for stiffer front end and a good rear shock. The bike never wallowed (like my ZZR600 did from new) but just never felt quite as 'right there' as the Blackbird on fast, well keeled over bends.
For the money, though, a superb bike.........but instead of getting another I bought a BMW Rockster.....and I love it!