If you can afford the anthology and get into it, you'll definitely get your money's worth. Even just a single playthrough can give you many hours of entertainment.

That being said, perhaps spend the evening looking up playthroughs of Civ6 to see if you think it will be your jam. Here's a playlist from a YT channel called PotatoMcWhiskey. I can't remember if this is the exact playlist I watched when I was considering buying Civ6, but it was definitely his channel that I found helpful.

I'd spend a bit of time watching vids like that, but if 25 bucks isn't a big deal, it's a solid gamble you'll get good time out of it. Also, I find Civ is GREAT for having something to do in the background while exploring new music on Spotify, YT etc.