I will say that there is almost zero use case for a
consumer to have a 15K Drive. 15K disks at this point serve two purposes.
1. Support the continued operation of old Enterprise Storage Arrays that don't have code supporting Flash.
2. Provide an artificial product tiering in the enterprise market that justifies the continued high prices of enterprise flash (if the only thing that existed was 7.2K Spinning Rust, and SSD, All-Flash would be price compressed down-market competing with itself. 10K and 15K disks help support higher pricing in Enterprise Markets for All-Flash).
A consumer does not have to generally worry about staying with an ancient hardware investment, nor do they need to worry about balancing a large array, or maintaining consistent deployment.
The reason your 9260 may feel fast is likely due to the RAM Cache in play that soaks up writes. It was of course originally provided to make up for the lack of IOPS performance from spinning disk, including 10K and 15K disks.
A 900GB 15K disk might cost you $90 on the used market. In RAID 6 with 4 disks you're managing You're managing about 1.8TB of disk space, numerous components to fail, a lot of power and heat, and still spending $350 on the endeavor. For $200 you can buy 1.92TB Enterprise SSDs with extremely linear latency, power loss protection, and performance characteristics from a single SSD that would put a 9260-8i with 8 15K disks to shame. That's why there's a bunch of them on the used market from EMC and the like using them as Flash Cache for their Storage arrays in front of whole shelves worth of disks.
As to the 512 vs. 4K thing. There is no performance disadvantage to 512e over 512n. None. The problem with 512e is that some systems won't read the "emulated" part right, and will still detect the disk as a 4K disk it can't use, rather than the 512e sector size. VMware was awful about this all the way to just a couple of 3 ago when they finally brought 512e support to 6.5, and only 2 years ago for 4kN support with 6.7. You have an old Gen 2 LSI Card, so it doesn't support 4K at all. 512n is the
safest bet to use with that old card, however 512e
is supported as long as you're on the MegaRAID 4.8 Firmware or higher.
For validation, see the Broadcom KB on the subject:
https://www.broadcom.com/support/kn...212.235523697.1586918084-415429152.1586918084
But again, an SSD would make way more sense here over 15K disks, and those old Enterprise SSDs all support either 512n or 512e due to having to work in the same environments as your old LSI card.