I am really pleased that you are giving it a try, we love TNI. What type of room did you reserve? East End Diver owns a Turtle Nest Condo and I have gotten a lot of great information from him!
Bodden Town is more of a residential area, unlike the much more popular 7 Mile Beach and West Bay, but we prefer to stay in a quieter, less developed, and less expensive area. And it is located in the middle of the island so you are not too far from anything.
The East End and North Point are nice areas, with good diving, but they are pretty far away and there is usually a 45 minute drive to most of the attractions, and that is a bit too far IMO.
TNI is a small family-owned inn. It sits on the water, there is a nice little beach, a small pool, and a big gas barbecue that guests can use. It is clean and pleasant and the people are lovely and you get maid service every day except Sunday - it's paradise - enjoy!