Depends on what kind of holiday you are looking for.
For liveaboards, it is really hard to beat Blue O Two - well-run, spotless boats that have a great reputation, particularly among UK divers. I was on a deep south trip last year and loved it. Their charters depart from either Hurghada or Port Ghalib (3-4 hours south of H.). Although I know you are in Canada, for reference you can find week-long trips for as low as 1,000 gbp/US$1,600, flights included (from the UK)....if you wait for discounted spots closer to the sail date.
Red Sea Liveaboard Scuba Diving Holidays | Egypt | Sudan | blue o two
For land based - do you want remote and quiet or with night life (Sharm)?
For quiet - Dahab or possibly a quiet lodge in the south:
I stayed at Red Sea Diving Safari with my family for a week a few years ago. They have a few locations in the Marsa Alam area - Shagra is the largest and busiest. We stayed at Nakari - much more remote, with really nothing around but desert and the sea. Lodging is very simple in tents or lodges. The itinerary is diving and snorkeling all day, quiet reading time in the late afternoon and early evening - very peaceful and relaxing. Meals were cafeteria style, with lots of simple but tasty food options - and the staff was really helpful in accommodating my daughter's vegeterian and wife's non-dairy eating preferences. Great dive staff who went out of their way to make sure our kids had fun (not really a kid destination unless your kids love being in the water all day). No TVs, no video games, no glitzy resort. High quality diving - shore, zodiac/RIB, off-shore on their larger boats, daily night dives. Snorkeling with dolphins at Samadai. Love the vibe there - kind of like being on a desert island in the desert
. It is not a place for everyone given the simplicity and remoteness, but you can rival a liveaboard in terms of the number of dives you can get in during a week's stay. You can stay there very cheaply. The major disadvantage if you are flying to Cairo is that it is a LONG drive (4 hours south of Hurghada).
RED SEA DIVING SAFARI - The Eco-diving Adventure - Home
Dahab is a little more developed than RSDS, but also a quiet, smaller town. We stayed there for a week in 2009. Very good diving infrastructure with many, many dive ops and a wide range of hotels from very basic to luxury. Shore diving and boat diving options. The scenery around Dahab on the Sinai peninsula is beautiful and dramatic, with large mountains springing up right out of the sea around the town. Climbing Mt. Sinai, quad biking in the desert, side trips to southern Israel or Jordan (we did a LONG day trip to Petra) are all options.
Hope this helps.
Chris