I haven’t been to Lighthouse Point, so I don’t know for sure, but if it is anything like Castaway Cay (I’ve been there a few times), there is plenty to do without booking an excursion.
Nassau is kind of a dump. First time we went we got off the boat and walked around the tourist market. The 2nd time we didn’t get off the boat.