In almost every instance of someone using a laptop for heavy CPU work, there is certainly a better, more practical reason to use a desktop. There is no need to sit at a coffee shop and make music, unless you do not have access to a studio or even your parent's garage. Video editing will not be done out in the field. It will, if done professionally, be in a quiet room with the proper equipment. Most of the time, someone that insists that doing either of these is just fine on a laptop, is someone that is young, broke, and doesn't have access to the proper tools for the job. Of course, the person pointing this out will get many downvotes...
Compiling Importing and Exporting from a database Photoshop load tests.
Also, I run a web server and database on my machine. It's just a personal preference for me. I do have a mac mini at home that I use also for stuff like video editing.
What I trade for portability is performance and I replace the machine more. I just keep everything important stored online and when my laptop dies I grab another and keep going.