Hi Stu,
Just saw your question. I own a TS at Club In, and have been there a lot over the past few years. The resort is particularly good for families with children, as it is just ground and 1st floor, with a very nice (but small) kiddy club, very easy access to the pool, and evening activities for all ages. It's not as "loud" as other resorts in Eilat, which we like. On the other hand, it is also pretty basic in comparison to other hotels in Eilat, but we have always been very happy with it. I don't know how it compares with hotels in the States, so can't help you there.
To get into the Eilat town center, you will need to either rent a car, or take taxis (relatively cheap) - it's about a 15 minute drive. If you are just adults, or adults and teens, you will probably spend most of your time in town, at the main hotel and marina area. As far as I know, you can use the pools and spa at the Club Hotel, which is part of the same chain as the Club In, and is within walking distance to town.
Right near the resort - within walking distance - is the dolphin beach. The underwater observatory is also very close, and very interesting for all ages. There are loads of things to do in Eilat, mostly water-related, and they will have a full updated list at the hotel activities desk, where you can also get discount tickets for some of the activities. A new Bible-theme park has just opened up, which I'm told is very good, but haven't been there since it opened. Other non-water things to do are Jeep tours, Camel riding, horseback riding, some interesting animal farms/zoos, hang-gliding, and tours to natural attractions in the desert nearby. There are also 1/2 day and 1-2 day trips that you can take from there, for example: the Dead Sea, Masada, Jerusalem, Petra (in Jordan). Again - all the details will be available from the hotel.
Hope this has helped, and please ask if you want any more information.
BTW, May is the best time of year to visit Eilat - the weather should be fantastic, and in the worst case, you'll sit out and tan
Have a great time !!