Been a dream project for years but when I first explored it a decade ago, cat6 was still new and expensive, and wasn't recommended because "who needs internet that fast".
When you're renovating that expense is relative imo. And the cable is relatively cheap imo. Nice wall sockets for them are super expensive though. 200 euro or thereabouts for 500m of cat6, but 20 euro per outlet pair adds up. Definitely still worth it, because like expected there's more stuff to connect.
As somebody who does networking for a jerb, you are getting ripped off if you are paying $20 USD for a CAT6 wall plate. What you want to get is punch down keystones and a keystone wall plate, at least half the price. Maybe that's what they cost at the hardware store though, I haven't ever had to buy one from there. I order all mine.
I use these keystone jacks: https://a.co/d/2sl6M8I. A bit expensive ($60 for 50) but they're toolless and work better than other toolless designs. Haven't had any issues with them. You can likely find cheaper ones outside of Amazon.
For faceplates, I usually use some like these Legrand On-Q ones, which are usually $0.99 each: https://a.co/d/ieAqlSq
I use keystone blanks to cover the unused ports (eg like these: https://a.co/d/3JYTdAq). I initially only had Ethernet near my TV, but I added HDMI too (using keystones like these: https://a.co/d/bknAVDc). Using the 6 port faceplate meant I didn't have to replace the faceplate when routing the HDMI through the wall.
This is what I did. Grabbed UL certified faceplates and a bunch of keystones. Total outlay was probably $50 including drywall/Sheetrock mounting brackets.
I went all out with Cat6A. I have some 10Gbps capabilities with my home lab, and although I currently do not have any 10GbE copper capable systems, I thought I'd try to go future proof.
My only regret is that I only went with riser grade cable - plenum was way too much, even for plain Cat6.