I stay ofetn in YYC and prefer to be at or near the airport. The Delta at YYC is by far the best placed but it loses out elsewhere in comparison to the Sheraton; which has bigger rooms, better in-room amenties, more modern interiors and a far better guest friendly reception area. The staff are helpful and its only draw back is that the airport is just a little further sicne they shut the McNight Blvd entrance to the airport restulting in an addtional 8 km;s for what is in essence an airport hotel.
It is however worth the longer commute. Nice bathrooms, complimentary water and helpful staff make this a very good airport hotel - though there are better located hotels if you need to be down town