We had some of Emergence filmed in my town, and I think law and order was here a few times. The last scene of the Sopranos was filmed a couple miles away.Clerks and some of Emergence.
I live in the Vancouver area which is also known as Hollywood North so tons are filmed here. You pass filming signs wherever you go. They are always filming close to my work and have even filmed at my kids high school.
Some I can think are XFiles ( early seasons) Riverdale, Once Upon a Time, Deadpool, Supernatural, The Flash.....etc.