I visit Bristol quite often on business and I like the place, especially the Old City.
Horts, on Broad Street, is a bloody good pub as is the Royal Oak near the Holiday Inn. I've found it to be an eminently walkable city, and have never felt threatened at any time.
Cardiff, however.........