Ressource intensiveness of the apps you use have nothing to do with being a "power user" or not.
I'm a power user myself. I haven't quite really "needed" a computer upgrade in the last 10 years, upgrading mostly on a "want" basis. I could pipe awk into sed into grep back into sed and into xargs 15 years ago. I still can today. I understand some of the subtilities of bash, none of which require more than a few MBs of RAM to run.
I used to optimize my config.sys and autoexec.bat to run ****** Origin titles like Ultima that didn't play nice with EMS, prefering XMS and tons of conventional memory, yet required a mouse (or bugger mouse.com, I'd just learn the keyboard shortcuts when I was on my fifth bootdisk configuration, thank god for the appearence of high memory, LH and LOADHIGH).
I wrote code in the olden days that a IDE was written in a Curse like API and that the system calls were all interupt based. I know of Mode 13h and yet prefer the niceties of Code Page 437. I remember what the web was like on 14400 bps, and even remember what it meant to download 100k over a 2400 baud connection.
That my friend is a power user. That he may use a program or two that is RAM or CPU intensive has nothing to do with being or not a power user. A normal user could require more than 4 GB of RAM depending on their workflow (engineering or CAD programs, high-end visualization, mathematics, creative content creation) and a power user might need less than 128 MB (old Unix greybeard that uses screen as a "GUI" and vtys for "virtual desktops").