Greek yogurt is very creamy but does have a tart after taste. If you like unflavored regular yogurt you'd probably love greek yogurt.
And the different brands do taste different. I tasted some at Trader Joes, then bought Chobani at Costco and it doesn't taste the same.
But I may be comparing apples to oranges because the Chobani I bought was 0% fat and TJ's was I think 2% fat. Fat does make everything taste so much better. That's why I'm so fluffy.