Queen Video is a community staple. In addition to having tons of movies you usually can't find anywhere else, they have a great staff who knows most of the movies that are in stock. Unlike those big movie rental chains, Queen Video has reasonable prices. 2-day rentals are under $5, while week rentals are $3.75. You can also rent entire seasons of TV for prices ranging from $6-$10 per week, depending on the show.
The other great thing about this place is how they are laid out. Most of the wall space is filled by the newer releases, but they do a good job of placing films out there that fall under the "I've always wanted to see this..." category. Even older TV shows will have its first season on display just to get you hooked.
Memberships are free and, as mentioned, the rentals are cheap. They even have a small section of used movies and dvds for sale for cheap cheap cheap.
Every neighbourhood should really a Queen Video of their own.