In general, boot choices start as leather or fabric, to keep them waterproof both types would need waxed / proofed.
Leather would typically be a bit heavier, harder wearing, easier to keep waterproof (less stitches), and probably more suited when going higher/rougher.
Conversely fabric boots would generally be a bit lighter, easier on more gentle walks, and may not last / be waterproof quite as long.
The Berghaus Superlites mentioned would probably be seen as representative of the best of the 'lightweight' leather boots; some fabric boots would actually be heavier and certainly less comfortable
Both types should be comfortable but lighter fabric boots would typically feel easier in appropriate conditions
In practice I wear fabric boots most of the time, and switch to the leather ones mainly in winter when I'm on rocky ground, snow & ice, soaking conditions etc.
There probably isn't a great price difference for decent boots, towards the upper end of your price bracket should get you good comfy boots in fabric or leather.