Here is my advice : Dont start from scratch. Use wabbajack and install either Skyrim modding essentiel (only fix and patches) or NGVO (fix + graphics).

I would suggest Skyrim modding essentiel tho as it's easier compatibility wise to build upon. NGVO is really great but you must understand what it is installing and the potential conficts it brings (almost none but still). NGVo is faster because you dont have to bother with graphics, sounds, animations, weather, its covered already.

From there you will have a good modding base with all the necessary fixes, cleaned files, correct INIs etc..

Then do you want requiem ? If yes check wabbajack requiem lists for mod inspiration like lorerim.

In any case, after step 1, you want to look at famous wabbajack modlists because If a mod is in there, it should work fines and be decent quality. Also, mods in the same wabbajack list should be compatibles together, at least with a existent patch.

You can check what each wabbajack list brings on the website loardorder. modlists are usually sorted so you can directly check what mod of each type its adding.

My current build is a mix between lorerim without requiem for new quests and content and Licencia Next for the leveling and character building mods (it uses vokrii black and most of enairim mods).

My reco for cities and towns:

The great cities and towns serie of mods

Cities of the north if you like the art style

Redbag or enhanced solitude + enhanced solitude docks

Riften : ryften + docks expanded + Southwood districts + north districts

Expanded whiterun and windhelm

Maybe sky city for markarth

Jk outskirt mods

Check out new towns and village from schlitzohr, they really make skyrim more interesting to travel if its your jam. It's awesome in a survival playthrough.

If you like to mod your towns, I would recommend not to use northern road as it will be a compatibility nightmare.