Since it's hard to improve core speed further, the only viable way forward is more cores. Not all problems can be parallelised though, so the set of problems that can be more efficiently solved in the future is smaller that previously. Old software is written for single core since that used to be the norm. In the future, more and more will take better advantage of multicore but, yes, it is (much) more work to do so at the moment, so it is avoided unless necessary. However, since your computer is often running a few processes simultaneously, these can run on different cores and thus in parallell, making a few more cores useful. Algorithms that benefit a lot from parallelising will be (re)written to take advantage of multicores sooner than other software of course, so if you need that kind of software it will be beneficial, video-editing I would assume is one example.
That said, unless you have need for computing power for some specific task you are better off spending your money on other parts of the computer like memory, good monitor that doesn't strain the eyes, nice comfortable keyboard and mouse and I never seems to have enough hard drive space (but hard drive space is mostly needed for media applications). You don't need a fast computer to write documents, use spreadsheet applications, surf the web, read emails or watch youtube.
You might also want to consider energy efficiency which also affects how much cooling and thus fan-noise is needed.