I've been working full-time remotely for past 5 years and tried many cities to live in. I feel like it might come down to personal preferences but I noticed a pattern in where I felt the best. London, Berlin, Chicago, Frankfurt, Bologna and Neapol would definitely take the bottom of my list. They are crowded, expensive and people are absolutely tired of tourists. Not to mention that all of them have some nasty places…
P.S. I will be checking out Faenza (IT) this year as well