My family spends every weekend at Long Point. It is a beautiful place and a very popular place. There isn't really much in the way of hotels there, just cottage rentals. You would need to jump on that quickly though because it is a busy spot. If you like camping, there is the provincial park. The closest hotels would be in Port Dover or Simcoe. There is a couple small restaurants in Long Point and Port Rowan. Nothing fancy, it is very quaint and small town. The beach is the main feature at Long Point and boating. Pontoon boats can be rented in port Rowan to expolre long Point Bay.
The Bachus Conservation Area in Port Rowna has some nice Trails and a pioneer village. Lots of neat events happening all year there. Check them out on line. Turkey Point also has some nice trails to explore.
Good Luck in your planning!
Lisa