As always, beauty lies in the eyes of the beholder. BUT I will claim that a Ducati Monster or a 916/996/998 are universally considered very good looking bikes.
I may agree that the Multistrada/ Hyperstrada/Streetfighter are not as great looking, just like a BMW GS, Most KTMs, etc. But all these bikes put function before looks.
In my book, 99% of japanese cruisers and Harleys, as well as most hardtailed XSes etc. just look SHIT anyway. Some dudes idea of "cool" and "style" creating poor ergonomics and handling, basically.
If looking for a new bike with classic looks, light weight, decent handling and power, check out the Ducati Scrambler. Way lighter than any other retro bike, and as powerful as a Ninja 650/ FZ 07/ etc. A Harley Sportster becomes a joke in comparison......