Where can I find out more about the "last mile" wireless links near the end of the video?

I will be moving to an retirement area that has a summer population of a few hundred and a winter population of many thousands. There is no internet currently aside from cellular. I wanted to look into long link wifi, but only have found expensive point to point solutions that are multiple thousands of dollars.

I don't even know if it is possible. The closest town is only a few miles, but I doubt Comcast is going to let me share a few business class accounts to all those users.

I was going to try to keep it free to near free, a few bucks a month and cover the equipment costs on my end up to a few thousand dollars. If I can't hook into cable without violation of TOS, then I have to go right to the telco and lease a line, which I have no idea the costs of these days. I would need at least several hundred Mb/s I believe. Hopefully there is a datacenter or ISP nearby that would allow me to work with them to put something on the roof or on a neighbors property.

Suggestions on resources?