As an idea to Munki and other people, I'll give you a list of what I enjoy using on my single player server, what I have recently had a fiddle with, and what I think of them. I may or may not also do a quick video overview of each so people can get a better idea, but that comes with whether I can be bothered lol
1)
"Structures plus (S+)" = love it, and will usually include it in each single player wipe I do, even if it's the only mod I choose to use.
2)
"Resource stacks" = same as one Munki uses
3)
"Pub mod" = also love it, however I know Munki may not want to use it due to the size but come on Munki... pubs
4)
"Saixang" = Used to love it. Now I would prob uninstall it given the amount of things you can do with S+ and that Saixang is a large file for a mod. Only issue is that I have a very big building that I have used saixang with a fair bit on my current sp file and if I uninstall it without replacing the building pieces it'll get wiped.
5)
"Forces of Nature: Lightening Storm" = this is good as it adds to the immersion on the island by making the storms really come to life. Only thing though, the .ini files need to be edited so that a giant red WARNING! doesn't flash across the screen just before a storm. Really annoying. There is also a chance of lightening striking a player, dino or structure and causing damage. Never had that happen though and been using the mod for ages now.
6)
"Better milk" = only really used on my SE server obviously. Love it though for my single player SE purposes.
7)
"Wyvern mating" = tempted to remove this. Not sure if it's ever worked.
8)
"Cooking extras" = I'm 'eh' about this one. It gives you a kind of 'nice' looking few features and 'kitchen', but in the grand scheme of things I wouldn't miss it if it were gone.
9)
"Advanced rafts" = still haven't fully explored this mod. But what I can say is that the extra items alone that it gives you for 'decoration' is pretty awesome. If you didn't have the pub mod, this mod still gives you many items that can be used to decorate pubs/inns/ and other role player buildings. Pretty cool. The boats you get as well look good, but are 'fixed' and can't be edited.
10)
"Upgrade station" = I like this, however I can see that it would make many other aspects of the game less worthwhile like the 'treasure hunting' and 'raiding' aspect in the game.
11)
"Advanced thatch" = I only recently downloaded this to fiddle with last week. It adds quite a few thatch/bamboo structures that weren't originally in the game but probably should have been. Would most likely be of better use for the pve and Whitelisted servers.
12)
"Egg and poop collector" = especially for single/solo players this is awesome
13)
"Meat spoiler" = that music!
14)
"Big Storage bins (b3.4b)" and
"More Big storage bins (v2.1)" = these are literally just for aesthetics on my single player servers. They create various 'storage' that is for a specific item, such as a pile of logs for wood storage, or bales of hay for thatch etc.
At looking at this list... I have a lot of mods lol. I have tried out a few others as well over the years, and uninstalled them either because they don't work, are corrupted, screw the game files, weren't interesting, were too much of a hassle given the little they offered, or just ruined the immersion aspect of the game in my experience (certain dino colouration mods fit this category as I personally think dinos that are too colourful aren't as 'natural' looking).
) and hammocks (hammocks guys... HAMMOCKS!!! 
)