8GB of RAM wasn't enough for me to use in either person or professional contexts in 2006. My work laptop has 16GB and I'm constantly running low on RAM when I'm working with spreadsheets and relatively simple Photoshop projects. I'm not talking about games or compiling code either.
I would not be looking at systems with fewer than 16GB of RAM for any user for any reason in 2024. And for myself I would not be buying any systems with fewer than 32GB of RAM.
(My personal desktop has 64GB and so far that's been sufficient but I have nearly capped it out when running substance painter, blender, unity, etc.)
So it really all comes down to the software you use. But my advice is to consider 16GB the absolute minimum.