I'm a software guy who doesn't do numeric data entry so for my use case I need arrow keys, function keys, page up/down and home/end. I also love my Delete key. A 75% fits what I do best though I could get by with a 65% and Fn the function keys. Some 75% keyboards don't have a PCB design that will yield all 5 of the Del, Pg Up/Dn, Home/End keys and a 65% will have room for at most 4 of those. I must have a discrete Del key and Pg Up/Down at a minimum. From there I can Fn the Home/End onto one or both of the Pg keys.

I just built the KDBCraft LEGO keyboard that is a 60% with arrow keys. I find this layout too inflexible for me for work as I have to Fn to get both Pg Up/Down and Home/End but I do have a Del key above the right arrow. And a very small 1u right shift to afford those arrow keys. For me, a 60% is just too limiting but I'm typing this comment on it so it's not like I can't ever use one.

What's great about the keyboard world is there is a layout for everyone. Pick your most common use case and what you can compromise for flexibility, accessibility, desk space and aesthetics and go from there. You might find you want more than one keyboard to switch between for different use cases. Maybe add a number pad if you do numeric data entry just once in a while. Good luck!

Oh, wanted to add that I can't live without QMK/VIA support for customization. I realize there are less expensive keyboards that allow customization with custom software but I prefer to use the open source approach and not run software I know nothing about. If you think you need to customize your keyboard(s) consider if customization is possible and what method is used. IMO the smaller the layout the more you'll want to customize.