There is very mixed feeling on here on whether downlighters are great or the work of the devil.
'tis true that not everyone realises that they are the latter. Or maybe they do, but they are dæmons
(A standard pendant, or a fluorescent tube are not 'nice' in my view)
Fair enough, although if you have the ceiling height there are some nice modern lampshades around and hanging lights around - you might need to google non-electric lights/lighting (I kid you not), and you see that type of lighting used increasingly these days. But another truth is that if all you look at is DIY sheds then pretty much everything which is not a recessed downlight is horrible. Remember of course that their buyers scour the world for the cheapest products they can find, and generally there is a good correlation between cheap and nasty.
I'm sure there are some good options out there, but would appreciate some recommendations, or things to steer clear of.
Rooms to be lit are...
Large recessed lights (LED or CFL, round, square, oblong) are ideal for places where you just want plain unobtrusive lighting, e.g. hallways, kitchen, bathroom etc.
Other rooms, beauty is in the eye of etc, but do cast
your eyes on lights sold by specialist shops and internet sites - you might be surprised.
Uplighters/wall washers can be useful in bedrooms and living rooms, as an adjunct to ceiling lights, as can table lamps and floor-standing ones. If you put in circuits using 5A sockets you can control those with wall switches. It's nice to have wall lights in the bathroom too, if anybody likes to have a relaxing soak.
Think if you could use cold cathode neons:
here's an example of that in a domestic kitchen showing that it isn't only suitable for nightclubs and hotel foyers:
(Ignore the fact that there are also recessed torches in there

)