
Multiple Brands
DF54 Series
Great value for espresso, but clogs and poor for pour-over.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
Medium to dark roasts Mazzer 233M is a great cheap option. Once you get into fancier more modern medium roasts SSP HU is the way. Honestly though I really love 233M for classic Italian blends
Get a Mazzer Super Jolly with manual doser off eBay, buy a small hopper and cleaning supplies and a good little scale for weighting your shots. This fits your budget squarely. The Super Jolly easily produces a grind quality with stepless adjustments on the same level as a 2000,-EUR Mazzer and fits the ECM perfectly. The only inconvenience will be either manually dosing (weighting) or living with grinding a quarter doser and using 1 or two day old grinds. A Mazzer with electronic doser is out of budget (those usually go for 300+), have a weaker motor than the Super Jolly, grind slower and come with a PCB that just about now can go bad and is very expensive to replace (if you can find spares). The Super Jolly will last forever and once you are ready for the next upgrade you will easily sell it on for at least what you paid for it. I keep one of them on the counter just for French Press but have used it for espresso before getting another Mazzer with electronic doser. Congrats on the machine. This one is nice.
When preparing coffee like French press or even drip filter machine coffee any 20 EUR bladed plastic grinder (chopper) can get you a reasonable cup of coffee. When preparing espresso though this all falls apart entirely. You need a very consistent, fine grind that is also prepared in a way that prevents the coffee beans from excess heat from the grinding action and ideally you want that grinder to last forever a veeery long time without needing spare parts, repairs and servicing. Consumer grade grinders that partly fulfill the requirements needed to produce the necessary quality grind start somewhere around 100-150 EUR (manual grinders) or electric grinders at about 150-250 EUR. These are consumer grade. Gastronomy grade (and luxurious consumer grade) grinders will typically start at about 450 EUR but more typically range in the 650 - 850 EUR price range. They are usually dimensioned significantly larger, using larger, slower rotating grinding disks or conical grinding mechanisms with slow rotating, high torque large motors, are made from premium materials with very durable construction (usually die cast housings over heavy duty metal chassis), high end models nowadays come with electronic precision dosers that precisely dose the ground coffee to fine adjustments of +/- 0.1g … These things are not trivial when aiming to produce consistently the best espresso based coffee possible. Unfortunately, this costs money.
I have two grinders... A modded Mazzer Super Jolly for espresso and a non-esp Encore for drip. I think the ESP will handle everything you want to do.
I love the Philos. My other Jolly lasted years—I'm talking like 10! I'm sure this thing will last another 10; it's built like a tank. A little big, but it doesn't take up as much space because it's big front to back versus side to side. Everything works great, even the metals they chose. I have like no coffee anywhere after several weeks of using it; it's crazy how good it is. Of course, this is my opinion, but I have owned five different grinders, and this is by far my favorite for a whole bunch of reasons, including cleaning.
Get a used Mazzer super jolly, and never have to buy another grinder!
I am AuDHD and have this flavour of neurodivergent noise “fun” aka torture. I have a Zerno Z1 and it’s not especially noisy. It’s near silent with AirPods Pro in on noise cancelling mode. I also cannot hear it when I use my custom IEMs. I had the Niche Zero and the Duo. The Zero was pretty quiet. I think flat burr grinders have a higher pitched scream than conical - but the Z1 is fairly quiet to me. I sold the Niche grinders. I also have an “AliExpress copy” of the HG-1 grinder which cost me around £400 a few years back. It is very quiet because you control the speed of the grinding with the wheel. So this is mainly the sound of crunching coffee beans and a low mechanical rumble of intermeshing gears. Do not buy a Mazzer Super Jolly. That thing was loud! I am happy to record the sounds of these machines if you want. Oh and to fully answer your question, the Z1 doesn’t have much in the way of safety features so you can absolutely load the hopper with a measured dose of beans (I use 17.5 or 18g) and leave it switched on…. via a smart switch like a Kasa Smart Plug. I use these for some of my home lights. The smart switch can be operated from your phone or you can ask a home assistant like google home / Alexa or whatever to turn it on/off.

Multiple Brands
DF54 Series
Great value for espresso, but clogs and poor for pour-over.

OPTION-O
Lagom Casa
Versatile, premium build, high clarity; slow for large volumes.

Niche Coffee Ltd
Niche Zero
Durable, easy workflow, great for dark roasts, not light.

Fellow
Ode Brew Grinder Gen 2 Series
Excellent for filter/pour-over, but cannot grind for espresso.

Baratza
Encore™ ESP Pro
Durable, repairable, versatile, but loud, messy, poor for light roasts.

Ranked #1
Multiple Brands - DF54 Series

Ranked #1
Mazzer - Philos

Ranked #1
Baratza - Encore™ ESP Pro

Ranked #1
Fellow - Ode Brew Grinder Gen 2 Series