Beauty is in the eye of the beholder and the Ninja is certainly a great looking bike.
I think the fact that the road destroyed your Camry is a red flag against buying something meant for road. You may want to do a bit of research around some of the adventure-style bikes. I’m thinking along the lines of the Honda Transalp or the newer Wee-Strom or Versys (price may be prohibitive). They may give you enough of the look you want and still have the suspension you need.
Another thought would be to see if you could try riding a dual sport on road. Many of them really are fun to ride and very versatile. They may not look as sexy as the Ninja, but the fact that you’ll have a bike that you can ride any time you want will be very attractive.