You did, until Golden Eye N64.
And many of those early games (Wolf3d, Doom, Hexen) didn't have Mouse look on be default, you played them Closed (Arrow Keys and Right Ctrl/Alt) or Open (Arrow Keys and Left Ctrl/Alt).
It really wasn't until Quake I/QuakeWorld that FPS' made the shift to Mouse+WASD. And evenstill in Quake1, mouse look was off by default.
Improvements in aim assist really make console FPS games more approachable. Still not up to the usability of a mouse, but if the game is thoughtfully designed it meets a "good enough" bar.
Although I wasn't a big fan of Rare's cursor aim functionality, it felt very clumsy.
Personally I'm a fan of sticky aim assist (halo) or snap-to-body aim assist (call of duty, gta). These kinds of systems are the kind of work where players may not even realize they are being helped.
But, my point is simply Golden Eye 64 was a console FPS where the controls weren't clunky (for it's time).
FPS stands for First Person Shooter. The games you're listing don't simulate much, even if some of those games have RPG elements.
FPS is too reductive. I'm using the phrase immersive sim in the same way as these articles:
https://www.rockpapershotgun.com/2010/06/29/dark-futures-par...
https://www.pcgamer.com/history-of-the-best-immersive-sims/
See also Wikipedia - https://en.wikipedia.org/wiki/Immersive_sim
HTH
First person immersive sims are generally best played on the PC. When consoles that were able to do decent graphics for a reasonable period (i.e. the pace of hardware evolution slowed) came into their own, third person control worked better with joypads, and for commercial reasons, PC games often ended up as a second-rate ports of console games, with compromised controls. You really need a mouse for first person.