We had
a visit in town here almost two years ago now. It was fun, but be prepared for snarled traffic. In addition to the Secret Service swooping in and closing roads (the main road on and off the Island, there is only one bridge, was "mostly-closed" for almost an entire day), there were thousands and thousands of onlookers who came at the same time. The helicopters circling overhead were cool to see though, and there were actually a few fighter jets stationed at our local po-dunk airport.
It just so-happened that my company had a conference that week at the same hotel where Obama was staying for the week, and I needed to travel back and forth between the Lab and the hotel a bunch of times. Nice to know I passed the Secret Service background checks (what they don't know doesn't hurt me, I suppose). I never saw him, but I did catch a glimpse of the First Lady and kids down by the pool at one point. And at one point someone came in to the lounge area where I was waiting with their dog, so I got to pet the First Dog. Bo was a nice boy, and fluffy.
A friend of mine had an even wackier adventure... She ended up out drinking one night with a bunch of people who worked at the White House and were along for the trip. They invited her back to the hotel for a bit more hanging out after the bars closed (we close relatively early here in Maine). She did, but ended up losing her ID, credit cards, and cell phone to the Secret Service at some point during the adventure, and then later because roads were closed and cabs totally unavailable, she had to walk 3 miles home at the end of it all (stopping to take a nap in Acadia for a while about 1/2 way home).
Unfortunately, by the time she got back to town and checked the hotel, the entourage had all departed (hangover certainly partially to blame). So, her "walk of shame" to get her credit cards and ID back involved writing an email to the White House rather than just slinking back into a bar the next morning!
Apparently they were friendly about it though and FedEx-ed it to her, so all was fine in the end.