I have been a couple of times.
The larger hotels will have more choice in terms of food. It's a muslim country, so no pork, so it is beef/turkey sausages/bacon/ham, so bear this in mind if you have fussy eaters. Trip advisor reviews and pictures will help you.
Staff are certainly friendlier if you tip, which annoys me. I prefer to tip at the end if a holiday for good service received, but in Egypt you basically need to buy good service up front.
My biggest gripe with Sharm is the airport. It's a pain in the arse, the staff are rude and on a power trip, they know you want to get home and absolutely delight in holding you up for whatever reason. Also make sure you're not a gram over weight on your bags, as they are very strict. There are multiple security checks, one before you enter the airport, the usual bag checks and then they pull people for random bag searches before you can enter the departure gate area.
We were there in April and it has put me off going back, but I have colleagues who go
twice a year