I can tell you out of 500 gb of my adult game collection, 99.9% are not what you wanted.

The main reason is, what you demanded are only possible with high budget project. And if the project somewhat managed to get low budget enough, it turn into something like "Seed of the Dead Sweet Home" or "GirlAndChainsaw".

You can try your luck by searching some producers with insanely large budget like "Illusion" or some producers I have yet to know.

I was very fond of "Succubus Heaven" by Chaos Gate, a relatively recent release that goes on sale at dlsite frequently. It's a roguelite sword n' sorcery game that endeavors toward a "party-based Dark Souls" feel and has H content both during battle & after defeat. I don't play tps games often enough to have experience to offer on that front however.

Platformer, but it's 3D, super high quality, good content, it feels like a PS2 game: The Fairy Tale of the Holy Knight Ricca.

Not sure if it's what you want but they are 3rd person shooter with ecchi contents

https://gtm.you1.cn/storesteam/app/1122040/Kaede_the_Eliminator__Eliminator/

https://gtm.you1.cn/storesteam/app/1948700/GunSoul_Girl_2/

Best way is to go find games on DLsite instead
Or wait for them to be here on steam
Like this one
https://gtm.you1.cn/storesteam/app/1988100/The_Kingdom_of_the_EndThe_Witch_of_the_Beginning/
It's a game from dlsite and it has adult content intacted.