I can take a stab at it, but I’m not super familiar with everything that’s out there so this is more of an ‘in theory’ perspective.
This isn’t useful information for you, really, but for context: I’m still using a Reprap Mendel90 that’s probably over a decade old at this point. It’s a slow but reliable workhorse, but I’ve definitely had a lot of bed adhesion fights with it. I’ve never been able to dial out the ‘elephants foot’ effect successfully, which is where the first layer or 2 is squished down and makes a thin ‘lip’ at the bottom of the part. I’m mostly printing practical parts so I just trim these off with a deburring tool.
My colleague has a Bambu Labs X1 Carbon that’s a truly incredible bit of kit and excellent value for money, but definitely on the expensive end. This is a great ‘it just works’ option. My colleague knows nothing about 3D printing and basically wanted the 3D equivalent of a modern laser printer, something that just works.
One of the friends that I mentioned bought a cheap Creality mini of some kind 3-4 years ago and never got it working. I never saw it in person, but he was having issues with getting the first layer to complete successfully. It always had the nozzle either too high so it wasn’t actually squishing the layer down, or too low so it was clogging the nozzle.
Another friend bought an Ender 3 when they first came out. I think he was mostly trying to print large blocky ABS models without an enclosure and had a ton of bed adhesion issues where the part would peel off the print partway through or pull up a corner. I think he ended up printing a few things in smaller pieces and gluing them together afterwards before becoming frustrated and I haven’t heard anything since.
Also not really a useful suggestion but out of interest: I have a TierTime Up Box Plus at work, as does another friend. They’ve been ‘ok’, but haven’t lasted well. As closed-source options go, they’re ok but I definitely wouldn’t recommend them. You need to use their software and there isn’t much ability to tweak things to allow other consumables to work. There’s nothing super special about them compared to printers of today, but they were a good reliable option 7-8 years ago.
I guess the main thing I’d be looking at would be how popular they are, first. A name brand printer with a solid community behind it is going to be easier to find help than with a relatively unknown brand. This is where I think Prusa shines, but also where Creality is a good option.
As long as it has a heated bed, you should be able to tweak it enough to work with PLA. If you want to print ABS, try pick one that either has an enclosure or could easily be boxed in without overheating the electronics etc.
If you want to print weird stuff like carbon-fiber filled filaments, glow in the dark, wood-fiber, flexible filament etc. then you’ll need to do some very careful looking into what extruders and nozzles are available, so personally I’ve never bothered.
From looking at the specs, most forms of Ender 3 look pretty good. That’s probably where I’d start, personally.
Edit: Oh, and I am looking to upgrade at the moment, but will likely go slightly higher end. Either the Prusa XL, Bambu Labs X1 Carbon or making myself a Voron 2.4r2.