We xposted

already confirmed Sand Farms +1 c to WT

Seems ok, as long as it is not 2 and added on mid-tech
According to Atreides UU - i think thy should be different
modcomp from FFH makes aviable command Post with Org trait.
Perhaps we can use that someway. MAy be National Wonder that permit contruction of those UUs. (Elite Guard Academy - perhaps there can be better name that i proposing)
Amazon = being Agg + Atreides linked = + combat 1 free - agg + stilsuit promotion (they wore stilsuit) or just +1 movement
Fish Speakers = march + 1 first strike
Ducal Guard = medic + 1 str?
I dont know what raw power they should be bu i think they shoud be very powerfull , something close to Noukkers, being 4 limit National UU.
About recources - i think that many of them are too common. I dont know yet which but i see much of them around every game.
1st - Diamonds. They appear too often to my taste. I just made large map and fopund that almost ever yciv have Diamon in their culture.
2 - Burro Weed - again - too much of them in every place of the map
i think halving those will do good job.
Every hapiness recource should be luxury
As for "dull" look of map - dont worry - there are plently health resources around , it would not look dull, change will be not sagnificant to change terrain look drastically