Competitive StarCraft (and it's successor) is very much alive still today! I recommend checking out sc2casts's best-of-year lists[0] for each year where you can find a selection of what ends up being the most "interesting" matches played throughout the year.
These can range from games that explore a new aspect of the meta, to nail-biting matches where the apparent loser makes an unbelievable comeback, to the career-making game of an upstart unseating the king.
(I have no affiliation whatsoever with sc2casts.)