I've been using xterm, urxvt, and st. Also tested alacrity, kitty, and wezterm. Your shell also plays a critical role in your terminal usage (but I won't deviate here).
For my use-case, the latter are overkill so I stayed with st. The only missing feature for me was image support even though I use it sporadically. To cover that I use a script that relies on ueberzug or ucollage if I need to browse folders.

I've wrote a small post about ucollage if you're interested.

Tilix is great, complete for my needs.

st on Xorg and foot on Wayland

Surprised nobody mentioned Yakuake. Just discovered it's just for kde. Been using it for years. It hides at the top of my screen and slides down when the cursor hits the top. Full desktop when not used and can access it no matter which app I'm using.

Foot because it's sway default. It's also configurable, has shortcuts and sixel support.

ghostty looks promising, but it's in "closed beta" for now. When it's released, it will be public and open source. :)

Good, updated article: https://itsfoss.com/linux-terminal-emulators/

http://contour-terminal.org/

Foot is the best

Xterm for me. As others have shown there are other ones that are newer than that but Xterm has become my favorite.

all of the fancy features that other terminals provide, I get with Tmux, so any emulator for me. I like transparent themes and that's easy to set up in Alacritty, so that's what I usually get

I run multiple terminal apps. I thought I would try a few, and I never deleted any of them.

I consider st a great choice when using i3 or dwm. Customizing it takes time, but RAM usage is what I usually check and in case of st it is comically small.