After asking a lot of questions (the above is a rough summary) this is the mod list I ended up with:
Fallout 4 Script Extender (F4SE): Install this first.
Unofficial Fallout 4 Patch: Install this to fix general game bugs and compatibility issues. Place it near the top of your load order.
Caliente's Beautiful Bodies Enhancer (CBBE): A popular body mod. Install this after the Unofficial Fallout 4 Patch.
Vivid Fallout - All in One: This mod improves textures across the game. Load it after CBBE.
NAC X - Natural and Atmospheric Commonwealth: A comprehensive weather and lighting mod. Place it near the bottom of your load order.
Enhanced Lights and FX (ELFX): Improves interior lighting and effects. Load it after NAC X.
Reshade and ENB Preset (Reactor ENB): Install your chosen ENB preset for enhanced shaders and visual effects. Follow the specific installation instructions for your chosen preset.
True Storms - Wasteland Edition: Enhances weather and storm effects. Load it after NAC X and ELFX.
Commonwealth Visual Overhaul (CVO): A complete overhaul that enhances textures, lighting, and more. Load it after True Storms.
Vivid Weathers: Another weather mod that pairs well with NAC X for atmospheric improvements.
Wasteland 512 Textures: This mod further improves textures in the game. Load it after Commonwealth Visual Overhaul.
Boston Natural Surroundings: This mod improves the environment around Boston. Place it near the bottom of your load order.
Enhanced Blood Textures: This mod makes blood effects more realistic. Load it near the bottom.
Enhanced Flickering Firelight: Enhances fire and torchlight. Load it after Enhanced Lights and FX.
Another Pine Forest: Install "Another Pine Forest" to improve the look of pine forests in the game. Load it after Enhanced Flickering Firelight.
Sim Settlements 2 (Core Mod): Install the core SS2 mod after "Another Pine Forest."
Sim Settlements 2 - Chapter 2: Install Chapter 2 after the core SS2 mod.
Sim Settlements 2 - Chapter 3: Install Chapter 3 after Chapter 2.
Sim Settlements 2 - Add-on Packs: Add any add-on packs you prefer.
Sim Settlements - IDEK's Logistics Station: This mod adds features that help manage resources in your settlements. Install it as directed.
Sim Settlements 2 - Compatibility Patches: If you're using other mods that affect the Commonwealth landscape, check for any compatibility patches provided by the SS2 community. If needed, install them to ensure compatibility.
Fallout 4 HD Reworked Project: This mod enhances many textures in the game, improving the overall visual quality.
Vivid Fallout - Roads and Bridges: This mod improves the textures for roads and bridges. Load it after "Wasteland 512 Textures."
Grasslands - A Fallout 4 Grass Overhaul: Adds lush grass and vegetation to the Commonwealth. Load it after "Vivid Fallout - Roads and Bridges."
Tales from the Commonwealth: A quest and companion mod that adds new characters, quests, and stories to the game. Load it after Sim Settlements 2.
Modern Firearms: If you want a wider variety of modern weapons in the Commonwealth. Load it after Tales from the Commonwealth.
K9 Armor for Dogmeat: Enhances Dogmeat's armor. Load it after Modern Firearms.
Immersive Wasteland Creatures: My additional choice. This mod adds new, immersive creatures to the Wasteland, making the Commonwealth feel more diverse.
Full Dialogue Interface: Improves the dialogue interface to display the full text of your character's responses.
Visible Companion Affinity: Adds a visual indicator for your companion's affinity level, making it easier to track your progress with them.
Place Everywhere: A mod that lets you freely place objects in settlement building, removing some of the restrictions of the vanilla game. Load it after "Sim Settlements - IDEK's Logistics Station."
KeyNuker: Helps clean up your Pip-Boy by removing the various keys and passwords that clutter your inventory. Load it near the bottom.
Better Settlers: Enhances the variety and quality of settlers in your settlements, making them more visually appealing and giving them better equipment.
Improved Map with Visible Roads: Enhances the in-game map by adding visible roads, making it easier to navigate the Commonwealth.
DEF_UI: A customizable user interface overhaul that improves the way inventory and menus are displayed.
Valdacil's Item Sorting: Enhances the sorting of items in your inventory and crafting menus for better organization.
Crisp: Complete Reskinning Program: A comprehensive mod that retextures numerous objects in the game for a more visually appealing and cohesive experience.
Darker Nights: Makes nighttime in the game darker and more challenging, enhancing the survival experience.
Crafting Workbenches: Adds crafting workbenches for armor and weapons to your settlements, allowing for better customization and crafting options.
QuickTrade: Simplifies trading with NPCs by streamlining the barter menu, making it more intuitive and efficient.
Fallout 4 Quickloot: Offers a quick looting system similar to that of Fallout 76, allowing you to see the contents of containers without fully opening them.
HUDFramework: A framework mod that provides more customization options for your HUD elements, allowing you to tailor the display to your preferences.
KeyNuker: Helps clean up your Pip-Boy by removing the various keys and passwords that clutter your inventory. This is particularly useful if you're playing with many mods that add keys.
Better Settlers: Enhances the variety and quality of settlers in your settlements, making them more visually appealing and giving them better equipment.
Improved Map with Visible Roads: Enhances the in-game map by adding visible roads, making it easier to navigate the Commonwealth.
Crafting Workbenches: Adds crafting workbenches for armor and weapons to your settlements, allowing for better customization and crafting options.
Reactor ENB: Your chosen graphics enhancement ENB preset.
AWKCR (Armor and Weapon Keywords Community Resource): Required for compatibility with many other mods and to ensure consistency in your game.
What do you guys think, is this a good, usable mod list, ready to download and play without needing to worry about load order or compatibility? (other than installing reactor ENB which offcourse requires some additional attention).
In general, this list can be a good starting point to build on in my opinion. Probably could still use some HUD improvement because I forgot to ask about that.