Definitely. I have had i3 on every computer I use for a couple of years now and I don't think I will ever go back to a conventional window manager.
No matter the thing I'm doing, every useful or efficient placing of windows is always no more than one or two keystrokes away.
Users have different needs and preferences, so I see the fragmentation as a positive thing because it gives people choice.
For me personally, xmonad, one of these hobby projects, has been perfectly sufficient for the last 10 years. I also didn't really touch my configuration much in the last ~8 years. More importantly though, I find it actually reduces my mental workload since I no longer have to handle window placement myself.