Tools to Avoid

Vortex
The mod manager was created around the idea of LOOT managing the load order, making modding seem simple and easy (see below why that's a bad idea).
While the option to manually order plugins exists, it's designed to be as unintuitive as possible - the user needs to select the position of every plugin from a dropdown menu, based on relative position to other mods (load X after Y, load X before Z), or use a graphical, node based interface.
Additionally, it does not track generated files, and the deployment logic can be confusing to the user.

Nexus Mod Manager
Outdated/abandoned, has no virtual file system or even dynamic movement of mods with loose files, which can lead to complete mod, or game reinstalls in case the user wants to change the load order, or installed mods in a wrong order.

Mod Organizer 1
There is no reason to use Mod Organizer 1 over Mod Organizer 2.

LOOT
The LOOT doesn't really have any idea about your mods and their inner structure - it just orders them based on tags in a masterlist managed by volunteers, meaning that it's impossible to account for every single mod out there.
While the Skyrim masterlist is updated often enough to make the tool viable for small modlists, you need to keep the above statement in mind and don't blindly trust the sorting result, especially considered how many mods keep coming out.
Incorrect load order will lead to overwriting or breaking features from mods.

Bashed Patches
These patches have their use cases and in skilled hands can save a tremendous amount of time. It's not that they should be completely avoided period.
However, like some of the other aforementioned tools, they are fully automated, and without the oversight of a human being they are liable to misidentify intentional overwrites as "conflicts" that need to be solved. For this reason, it's only recommended to use them if you are both capable and willing to comb over the resulting patch.

Mator Smash
Outdated and produces broken patches. The only viable method of automated patching available is through a properly utilized Bashed Patch thanks to its sophisticated tagging system, which allows the user to customize how the generated patch handles individual records.

zEdit/zClean
Neither have any real advantages over SSEEdit, and lack some essential features/support than SSEEdit has due to outdated codebase of these forks.

Merge Plugins Standalone/zMerge
Automated merging can potentially cause major breakage in mods, especially heavily-scripted ones.

FallrimTools Cleaning
Cleaning save files with Resaver will only cause issues, there is nothing that needs to be done if you followed the guide properly.

Ordenador/DDSopt
Breaks many textures by needlessly converting/adding/resizing alpha channels, cubemaps and mipmaps. Use Cathedral Assets Optimizer or BSArch Pro instead.