Having just gotten back into this "sport" after a 50 year absence, I'll throw in my experience.
My original huge HO layout way back when had all automatic switches. Pretty neat when you are 14 or 15, to sit with all of those switches in front of you, pressing the buttons, hearing the buzzes and then the clicks. You feel like "an adult."
But now, getting back into it on an O scale basis, I have just completed a layout with 6 switches, and I made them all the old-style Lionel 041 switches, with the revolving lantern and the big red upright lever. A key here is that they are all within easy reach, no further than 12 to 16 inches from the front edge of the layout, and all within about a three foot horizontal area.
I find that I just LOVE reaching over an pulling those red levers when the train is coming around the big bends, heading for the switches. The switches make a nice click sound when you throw them, and you really feel like you are involved with the moving train and layout. In modern terms, they make it a more "interactive" experience. I also like seeing all of those red and green lights come on when I plug in the transformer. It makes the whole board come alive and lets me know that current is running everywhere. And, best of all, it makes you feel like "a kid."
I would suggest that you buy a couple of these old switches, install them in places within easy reach, and just see if you like operating them. You may be surprised.
As a caveat I would add, that I don't "do" railyards. I've never liked them. Nothing under the sun more boring to me than backing trains up over switches and turning the tracks off. And, I just don't think anybody would enjoy hand throwing the switch levers just to back engines or cars in or out of a yard.