So far, my favorite typing experience is with an ergo-clears or Zealios and an OEM profiled PBT keycap on an aluminum plate. For work, I use Zealios with GMK silencing clips on an a steel plate with GMK keycaps. I love the quiet that this combination produces, especially in the office, but the reduced travel is a bit jarring. Perhaps if I had an aluminum plate with a little more give instead, that would make the experience a better.
I've tried various weighted springs, tactile vs non-tactile switches, and different key profiles. SA keys on light springs don't work well for me, but paired with tealios they feel really nice.
Unfortunately, with so many options, I think the best thing to do is experiment. The feel of a keyboard will be subjective. I would recommend finding a keyboard that will allow you to hot swap key switches. Obviously try cherry reds or browns. There's a reason why these are some of the most ubiquitous key switches. They work for most people. For me, anything more than 67 grams is a heavy switch. My typing accuracy diminishes quickly and I experience fatigue.
From ZealPc, try 62 or 65 gram Zealios. 67 gram telios feel good with SA profile caps.
From Gateron try the yelllow switch. Feels like a cherry red, but with more cushion at the bottom.
From NovelKeys, try the purple Kailh Pro Switches. 50 grams tactile.
There are many options to choose from! I only listed a few I have had nice experiences with. I intentionally left off any sort of clicky switch. I've tried em and they don't work for me.