Hey these are valid questions, but they are very basic.
So pardon the instruction session ...
Read Intensive drives will burn out more quickly. In some cases A LOT more quickly.
You want MU ... Mixed Use.
They make Write Intensive drives priced similar to MU, but they I don't see any advantage to them.
I don't recommend any particular drive vendor, but these guys have a nice logical site that makes it easy to find the right stuff.
Use this for reference, and follow along.
https://www.harddrivesdirect.com/dell_build_PowerEdge_R250.php
Your PowerEdge R250 comes equipped with a 12gb backplane.
SATA is only 6gb.
Look at the list. Scan down past all the SAS to where the SATA starts.
See? Everything below that line is 6gb.
I run SAS everywhere, professionally, and even in my homelab.
Not SATA.
You've indicated you are shopping for SFF (Small Form Factor) or 2.5" drives.
Your PowerEdge R250 was only released with full 3.5" bays.
So if you want to install a 2.5" drive of any sort, you are going to need a hybrid drive frame.
Are you actually pricing a Hybrid drive, and just quoted the 2.5" mounted inside?
You need to figure that out. Really. Look at the exact model and start googling for pics.
Back to that page.
I saw this 960gb drive under the second section "Dell PowerEdge R250 Options - SAS Hot Plug 3.5" (LFF) Mixed-Use (MU) Hybrid Solid State Drives (SSDs)"
400-BCNP Dell G14-G16 960-GB 3.5 SAS 12G MU
Hmm. They want like $850 for it.
Take that product description and search ebay.
There it is, brand new, for $700. With pics.
... And ... the disks are too small.
Go with bigger disk to start, so you don't have to buy twice.
-------------
I should not offer this advice. So, its not advice.
My primary homelab box is your machine's older brother. I run a R230 in my bedroom.
That machine, if you have the riser installed, has exactly 1 PCIE slot for you to use.
And in that slot, I installed a single device that hosts a pair of Gen3 NVME and a pair of 2.5gb NICs.
https://www.qnap.com/en-us/product/qm2-2p2g2t
I don't know if its on the Dell approved hardware list, but this is a class above consumer gear.
iDRAC knows about the NICs. It even sees the new RAID controller, and its bootable.
Made to go into a NAS. Radically extends the limited capabilities of that low-end server.
When I add it all up, the card and a pair of large, heavy-duty (Gen 3 or 4) NVMe cost considerably less than the native SSD quoted above.