Would it be good to have denser transistor counts? Sure. There are lots of benefits for hardware. Denser transistors can mean (possibly) reduced power consumption from smaller chips. Manufacturing costs are reduced because you get more chips from the same materials. Device production costs are reduced because you can combine functions that used to take two chips into a single chip. Overall devices can be smaller.
But from a software perspective, its a limited blessing. To be sure, there are benefits for cloud computing applications and other "embarrassingly parallel" applications. These chips might be great in data centers, which are power sensitive. And being able to do more things at once can be good, even if its at the same speed - Google can maybe crawl the web more frequently and video games might get improved graphics.
But the thing is, we already have nearly unlimited computing power at our disposal. On a whim, I could spin up a hundred thousand computers on Amazon Web Services to do some desired computation (which would cost a mere $700/hr at the current spot prices). My laptop has a 192 core GPU which, by itself, is more powerful than most super computers that existed up to the mid-1990s.
What we really need are software advances to exploit this hardware. For decades, there has been essentially no progress whatever in software that can take advantage of parallel computing. What techniques we have are either brittle (threads) or forfeit most of the hardware's power (multiple processes combined with relatively slow inter-process communication). Software is in such a backward state that people are amazed when the home-screen icons on an iphone scroll smoothly from page to page.