Cinelerra can be great sometimes. If you build it yourself, it can be stable, and if you already know Avid, the interface isn’t that bad. My main complaints about it are that exporting is difficult and that dealing with image sequences is clunky. I have high hopes for Lumiera, which is a major UI rewrite for Cinelerra.
Blender is my main favorite, and I use it most of the time, but it’s not the one I recommend. Like everything else Blender does, it’s really fast and powerful once you get into it, but if a person is unfamiliar with Blender, they’ll just think it’s too weird. On this forum, this shouldn’t be too much of an issue.
Kdenlive is the one I reccomend in most circumstances. I particularly like the way that it doesn’t try to do everything itself. For example, it integrates well with Audacity for sound mastering and Gimp for titles, instead of forcing us to use their own lousy title generator. The export presets are also very convenient.
There’s also Pitivi, Lives, DIVA, Open Movie Editor, and Kino, but I don’t really like those very much.
I also use DVgrab to capture miniDV & HDV tapes, and that program is wonderful. FFmpeg is also very useful. Both of these are CLI apps.