I have never found a hat such as you are looking for in city use without looking like a beek. So I usually just wear a baseball cap if needed. For more non urban outdoor activities, I have a old floppy brim style hat but rarely wear it unless it is very hot (+80F) and the sun is beating directly on my head.
_________________________
Earth and sky, woods and fields, lakes and rivers, the mountain and the sea, are excellent schoolmasters, and teach some of us more than we can ever learn from books.

John Lubbock