The easiest answer is "it depends on YOU". I myself moved here 2 years ago because I wanted to visit the parks anytime I wanted to. We were engaged at the MK, married at the Grand Floridian, plus we wanted more reasonable house prices.
Also, I'm the type of person who tends to "burn out" on things after awhile, so there was the potential for this to occur. But the end result is that I enjoy it EVEN MORE than before.
When we first moved down, we went all the time, so there was a slight burn out period. We were also adjusting to living in a new place, being away from family, etc., so it was an emotional roller coaster for us.
The way you visit the park will be different. We don't wait for anything with a long line, since we know we can come back anytime. We usually only go for about 4-5 hours at a time as well. It's exciting to know we can go to all the special events, such as Star Wars weekend, Flower Garden Festival, Holidays Around the World, Food and Wine Festival, Halloween party. I actually appreciate it even more.
The only negative is that you lose the feeling of being on a vacation and not thinking about anything else for a week and the joy of staying at one of the resorts. But the trade off was worth it for us.
Like everything in life, it is what you make of it