I like the museum and my early artifacts have definitely helped me to upgrade more quickly. I've been seeing All Resources artifacts less often, but I did get a first-tier starting 11% one yesterday that I sold off, so they are still out there.
I think the important thing to know about the artifacts is what to look for. Initially, I thought getting an artifact that had both tiers 1 and 2 unlocked was good. That's rarely the case. Instead, you need to look at the starting percentages on every tier. The highest you can get on a regular artifact is 11% starting on every tier. The highest on a war artifact is 6% starting on every tier. Knowing this, you'll be able to quickly look at the starting percentages to evaluatel whether or not it's worth keeping. There are a few exceptions, though.
I have a few artifacts that I use temporarily and I don't expect to unlock higher tiers. Some good temporary use benefits are: Vault Capacity, Vault Interest, and discounted costs like Forest Expansion Cost Refund or Library Tech Gold/Food Cost. You want to really look for good starting percentages in the first two tiers, since you'll be swapping them in and out only when you need them, so the later tiers are much less important. For example, before you collect from you vault, load artifacts that increase the vault interest. Then before you put the resources back into the vault, load artifacts that increase the vault capacity. Similarly, before you spend resources to research something or to clear away a forest square, load artifacts that reduce the cost. And if you get attacked regularly, you may want to load artifacts the increase the refund you get when someone raids you instead of the more offensive-minded artifacts you'll want for when you go attacking.
You can also increase the capacity of your museum from within the museum to hold more artifacts. This was always pretty helpful, but now with both raid and war artifacts, it's pretty much required in order to hold everything you're going to need. Avoid building one artifact at a time, but instead build 5 whenever you have enough fragments. How much you upgrade the tiers after that is really up to you, but IMO it's worth upgrading every tier of an artifact you're using to at least level 2 since the first upgrade cost is so small (40 blue scrolls).