I don't mean these Flock cameras, I mean what you refer to as "boring rooftop weather webcams". Some of those show people fairly close up and even if you can't recognize your face in the stream, you will recognize the place and realize that it's you, standing there right now in that video stream.

Just search for "<your city> webcam" and see what you can find.

Some places have them available. For example, every highway camera in California (and in some places like Oakland there's plenty of cameras that show crosswalks): https://cwwp2.dot.ca.gov/vm/iframemap.htm

Quality isn't great, but you could likely see yourself recognizably.

Many are! I live in NY and 511ny.org has a great view of all traffic cams in the state (and some beyond it, but I don't understand how they got on the list...)