A camera/video covering the public sidewalk, public street or common driveway is a no nevermind.  

It can be anything from a tenant tripping on a step, falling from a balcony, a guest or passerby slipping/falling on the sidewalk.

Anything I should attempt to do about all the cracks in the sidewalk?

That means you need to start looking for market inefficiencies (prejudice).Look South side. Walking

In big cities like San Francisco, often the tall buildings own up to the roadway, including the sidewalk that the general public uses daily.

Make the tenants go to the public sidewalk or street where they won't bother other tenants, inside or out. 

I know on one house I purchased we had a sidewalk issue that I had the seller fix before completing the deal. 

We listed down some cons that we came up with and I'm wondering whether these would be an issue for possible renters in this area.Steep short driveway, no side walk on a semi-busy street, smaller living and dining area, listed as 3 bedrooms but actually looks like 2 and half bedrooms (doesn't look like it would work for a larger family), entrance to basement is outside.Pros are interior is fully newly done, smaller yard and driveway so less work (landscape and snow removal) and the taxes are lower, close to the train station and stores.Wondering whether I'm overthinking it or this is not how possible renters would view this as a possible home.

Snow removal: In most cities, you are liable if someone slips and falls on your sidewalk if you did not remove the snow or ice on it after a certain amount of reasonable time (24 hours for us...). 

HVAC, water heaters, appliances, flooring, paint, driveways, sidewalks, sewer lines are just some of the many things that may need replacement within 20 years.