So it sounds like you’re after something that prioritises espresso only, with milk drinks as an occasional requirement. Your comments on coffee preference being less acidic suggest that profiling might not be that important. It’s more valuable with light roasts that are harder to extract. There’s no harm in profiling, but I suspect a standard 9 bar with pre-infusion will get you coffees you like.
Given you are going to be drinking mostly black I would prioritise this. To me this means good temp stability. I would therefore recommend a pid controlled single boiler (if you don’t mind the pause to steam), or a pid controlled double boiler. I would avoid heat exchanger machines, as they compromise temperature control for steaming. This is a reasonable compromise if you mainly drink milk drinks, but probably not the right balance for you. Probably the only exception here is the lelit MaraX v2, which I understand has a mode that prioritises brew temperature if you’re not steaming milk.
Looks are clearly important to you, and while every one has different taste I personally would only have a machine I like the look of.
For sound I think it’s worth trying to see a vibe pump in use. I know some people are very sensitive to noise and it’s very important to them, but I don’t find a vibe pump that noisy. It’s certainly not an issue to make a coffee in the kitchen when everyone is asleep. They’re cost effective and they work well. For me I would consider a rotary pump wouldn’t feature as a deciding factor.
Enjoy the decision making process.