It takes a rare individual who can live with floating shelves and make them look good at the same time.
I read an article on decorating open shelving once and there were lots of rules.
* No more than 30% of any given shelf should be occupied.
* You should have items of differing heights on each shelf.
* If you have a cube shaped item on one shelf, you should not put a cube shaped item on an adjacent shelf.
* Items should be decanted; nothing should be in the manufacturer’s packaging…
* Yada, yada, yada.
In addition you have to dust them frequently, make sure that they are aligned nicely, etc.
In other words, open shelves are a task-heavy storage option.
All those tasks disappear with closed shelving. Closed cabinets also allow for greater storage density.
Having tried to discourage you, I have seen images with LED light strips attached in dadoes, so that the light is seen and not the lights. I would do a mock up to determine the best location of the light (towards the front, middle or rear of the shelf).
My kitchen under cabinet lights range in intensity from a night-light-glow to reading-light-intensity. I mostly leave it as a night light.
I used to have a large collection of books (I now use a tablet for reading). When my book shelf grew too full, I endeavored to donate books to friends and relatives according to what I thought would interest them. My only rules were that they were not to be returned to me, and once they had read it, they should give it to someone else.
That backfired. For every book I gave away, I got three gifted to me from those same recipients. So instead of emptying my shelves, they remained full with stacks of books in the corners of the room.
As you can tell, I’m not a fan of open shelves, and floating shelves are the most visible, so your decorating faux pas will be most noticed with them.