We (and
@Alexle2007 ) stayed at the Sheraton Sand Key, and I know
@Judique has stayed there also. I liked it. It is not in the Clearwater Strip, which I personally loved, but I think
@Alexle2007's family did not like that. It was an easy trolley ride to get to the busier Clearwater area. I walked for miles on the Sand key beach and saw maybe 10 people total. On the Clearwater side you will have 10 people in your personal space at all times. This was in June, so not sure how it is if you are looking off peak. We took the Trolley all the way to Dunedin. It was a cute little town. We just walked around and ate there then took an Uber back to the Sheraton so we didn't have to wait on the Trolley. The Trolley was easy enough, but we had to transfer and had a little wait in the town of Clearwater (not the beach area) and it is strange over there. lol The town is apparently mostly owned by the Scientology Church. We thought there was a big resort that had a massive shift change while we were waiting because all these people were walking around in uniforms. Nope, it was church members. I don't know anything about the church, hope I don't offend anyone, not saying anything bad about it, it was just strange. Have no idea why they all dress alike.
So are you looking for beach activity or something else while staying there? Quiet beach activity I would pick the Sheraton (or Marriott across street). In the middle of everything beach activity then Clearwater Beach area or quiet quaint little Downtown area then pick Dunedin.