Having a 2nd/holiday home can be a tie, especially if it’s a fair drive away, we bought a 2nd home in the Lake District about 6-7 years ago. When we were there we found it hard to go back to our main house! After about 6 months the GF’s boss was moving and she said she wanted redundancy and got it, I work from home so we moved up to the Lakes, best thing we’ve done. We were planning on on living there anyway it just happened sooner than we thought.
Do it if you don’t mind the drive and wont get to attached to it and it doesn’t need much work IMO. In the winter can be a worry not being there with frozen pipes etc.
If you’re going to let it out you’ll need someone to do the changeovers or pay an agent which can eat into the money you make, some agents take a high % for the full service.