Great post! I agree this is one area today where there are a lot of opportunities. So many small to medium local businesses have a non existent to poor web presence and you as a web marketer can help them out.
Looking at local keywords for example (at least for the place I am staying); SEO wise many niches are barely touched. Flower shops, fitness clubs, plumbers are easy to rank for, even for a noob marketer.