Audio, video, and 3D animation are still extremely processor intensive. You need something beefy if you're serious/professional about those.
Office tools and web browsing are less demanding.
Office tools and web browsing are less demanding.
But you can get way better results with the lowest end computers than you could years ago. Back in the 90s my grandfather used 3DS Max to map out his future apartment's rooms and start planning furniture, using renders to get an idea of how sunshine would look like at different times, etc. At the time, he did this on an expensive 486 that would take an entire day to render some of those visuals. Nowadays I can do the same with a free copy of Blender and any reasonably modern integrated GPU in probably under an hour.
Try seconds or at most minutes.