Scott D. Pierce: Gays, lesbians, transgender people and ‘Tales of the City’ just aren’t that shocking anymore