Curious what machine you have and what its configuration is.
Actually, those are very much edge cases. My b/f has a 2019 Mac Pro, with a Vega Duo, and 96GB of RAM and a 16TB M.2 RAID. He uses After Effects (although has mostly switched to Fusion - better, more powerful, stable and reliable), Premiere and DaVinci Resolve (now his editor of choice). He used to use Photoshop, but now almost exclusively uses ProCreate, Affinity Photo/Designer/Publisher, and Pixelmator Pro. RAM has not been a problem for him, but having more/faster video RAM would be great. Most of the video we shoot is 8K Blackmagic RAW and has never been a problem for his system.
Yes, Adobe’s products are pigs, but we have not seen a need for that much RAM.