If you're in a city or suburb with a Google office, it's spotless, including transit options that are often customized to the city itself.
If you're in a city or suburb without a Google office, it's reliable on roads but probably doesn't cover transit particularly well. I'm not sure if the Google vs. non-Google office is just a bias towards the kind of cities Google would put an office in as opposed to the presence of an office making a difference, but Pittsburgh is much better than Columbus or Jacksonville despite being a smaller city.
If you're in a rural area, it's much rougher. Private roads marked as public roads are the biggest thing I've noticed (presumably because aerial maps can't help much there), but also things like ATV tracks and driveways marked as roads and missing one-way indicators (i.e. routing the wrong way up a one-way street).