Bioshock Infinite is one of the most acclaimed games in the last few years and only two from 2013 are rated better. It has a 94% Metacritic rating and was declared a 10/10 game by dozens of reviewers.
No idea about profitability, but it was a great game.
People retrospectively don't like it because it didn't live up to some of what the trailers promised (in terms of how large or open the city was) and the dimension tearing mechanic robbed it of weight for some ("If this is just one version of how things play out then what's the point?" Missing, of course, that THAT is the point).
Personally, I really enjoyed Bioshock Infinite including the so-called "Twist" ending. I did not see it as a Twist since they very obviously foreshadowed it. But to each their own.
No idea about profitability, but it was a great game.