Overall, this sounds like a really good change for Steam. Instead of Valve manually picking things, or developers scheduling specific stuff to get a slot - you will hopefully see more of what you're directly interested in.

No this is not a good thing. It's going to result in you just being shown the type of stuff you play. It's literally no different to the Youtube and Facebook algorithms that just ensure you see nothing but the same shit in a different package all the time.