A ticking HDD can be heard over other noises in less graphically demanding games.
WIth SSD prices there is little reason to put any games on a HDD. I have everything from open world games to point and click adventure games like Monkey Island and Broken Sword series.
I have a 4TB HDD that is just for movies and pics so I moved my user folders for those to it. (Except My Documents)
I then have a 1TB SSD for games storages, its barely half full at the moment and I have space in the case to add another SSD if I need it. I also put my “my docs” on there for quick loading of any saves and stuff on there.
I also boot off an M.2 which has my big sandbox games on like Skyrim and flight sims, they take up most of the room on it with the OS, with just enough space for safety!
If you are short on space you can keep games on the HDD but swap them with a similar sized game using Steam to the SSD when you know you want to play them.