Earlier quoted context omitted.
Only After Effects doesn't have an all-in-one competitor, really. Photoshop/Illustrator/InDesign, as a linked suite, has a very, very able competitor in Affinity Photo/Designer/Publisher. Given the complexity of these products, expecting more than one fully-integrated competing suite might be too much. You might find this video useful, to see the extent to which it is a competitor: https://www.youtube.com/watch?v=UVq…
Last I looked for a replacement for Lightroom I didn't really find anything that worked well for me. Maybe the open source tools have matured in the interim? I've been sticking with my old copy of Lightroom 5 and until I buy a new camera that it doesn't support processing raw files for.
Because I don't really like working in "sessions" and prefer folders, what I do is use DxO PhotoLab (which now comes in an "Essentials" version when you get it with their Nik tools, which might appeal to you). It's fast enough to cull in, though for really fast culls I use Fileloupe on the Mac.