I guess sour cream is not the flavor you might be looking for in a yogurt to eat straight up, but good to know for substituting
I like chobani, some people have suggested straining regular yogurt to get the consistency you might like something that's in between regular and greek. I find that I like only certain flavors of certain brands, so maybe trying a different brand might help.
but hey, if you don't like it, think of the calories you save by not eating it!