Hi Susie,
I have a different model of Sony 4k android TV about a year now & am very pleased overall.
Re Kodi etc, bear in mind this is a Sony android TV which is different from a generic android box. So the official apps and uses are more limited and if you want to get into Kodi (primarily used for streaming free content which can be a grey area at best) it will take research & workarounds etc.
I have no interest in getting into that myself but have found the android TV very useful.
It gives you apps for Netflix, Amazon prime & YouTube etc built in, so you have them all at the touch of a button. Netflix would be our only source of 4k content at the moment (dearer subscription price for 4k) but more streaming services will support it in the future.
You also get Google Chromecast built in so you can cast content from your phone/tablet to your TV from various sources (e.g. channel 4 all4 catch up app) which is very handy.
Finally, a few things to be prepared for when buying any new TV:
1) you will likely need a separate sound bar with typical cost of 100-300 euro. New TVs are so thin they have rubbish sound. Even if it sounds ok in the shop etc, you will probably need one in reality.
2) many modern TVs are very reflective, so you may find lights etc reflecting in the TV when they didn't before.
3) many TVs are best viewed straight on & may not look as well from different angles, which is a concern if the TV will be in a corner. In that case research the optimal viewing angle range before you buy.
Hope this helps!