You will get a ton of advice here on a question like that (since there are so many options) that will be helpful but also maybe overwhelming.
First, be careful of off-site hotel claims about distance to DLR. Some are literally across the street from the parks but not across the street from the
entrance to the parks. They thus may be a 1+ mile walk to get from the hotel to the park gates even though they are "across the street" or "one block away".
So before you choose a specific hotel, decide which of these categories will work:
1. Onsite Disney - close to parks but expensive (even more expensive than WDW hotels, and DLR does not have any Value options)
2. Offsite Easy Walking Distance - most of these are decent enough hotels, but not Hilton/Sheraton quality. More like Best Western/Marriott Courtyard/Ramada Inn quality.
3. Offsite Too Far to Walk Comfortably but More Upscale - Lots around Anaheim. Like 1-2 miles. Hilton/DoubleTree/Sheraton/etc. Note some of these hotels are south of DLR on Harbor Blvd. and easy to get to the Toy Story Parking Lot which has Disney buses you can ride to DLR.
4. Offsite but you do not care where because you will Uber or Lyft - Lots of those too. See this recent thread -
https://www.disboards.com/threads/where-do-uber-and-lyft-drop-off-at-disneyland.3629816/
Whatever you do, do not stay offsite, rent a car, and drive to the parks. The least efficient option. See "Hidden Time Losses When Using a Car At DLR"
www.disboards.com/showthread.php?t=1381580
For me, I only do #1 or #2 based on this thread I wrote - "HydroGuy's Hotel Rule"
www.disboards.com/showthread.php?t=1199862
Number one key advice I have is do not make the classic WDW vet mistake about hotel choice. Since WDW vets are so accustomed to buses to get to parks, they choose a hotel farther away and plan to take a bus thinking it is like WDW. Yes that works, but it gives up a huge DLR advantage that it has over WDW with so many closer hotels where you do not need a bus. And it can waste a lot of time unnecessarily. See my Hotel Rule advice linked above.
The absolute closest off-site hotel is the Best Western Park Place Inn. This hotel and those near it on Harbor you can literally walk from your hotel room door to the park gates in 5 minutes if you hit the crosswalk light just right. Think about that. A hotel where the room to park walk is closer than some of the bus or boat drops at WDW are to the parks.
I had four sons and we have stayed at the BWPPI mini-suites many times. Sleeps 6 with two QBs and a couchbed also Queen size. Small fridge and microwave. Nothing fancy but nice enough and very close.
My #2 offsite favorite is Candy Cane Inn which is a notch up from BWPPI and lots of people around here like it. They are a little further from DLR but still walking distance if you have to. They have a shuttle that runs every 30 minutes and so I only walk when I mis-time the shuttle pickup and do not want to wait 30 minutes for the next pickup.