"Standard" Footprint for SMD Crystal
There are three general SMD crystal package types in wide circulation: the HC-49/SMT, the "sideways can", and the 4 pin LCC (leadless crystal carrier).

Out of these three, the HC-49/SMT is what I would recommend for MHz crystals -- it is a gull-wing package and chunky enough to be easy to handle and solder.  The downside is that it is chunky -- it's a low profile HC-49 adapted for SMT use, which makes it almost like an SMT electrolytic can size-wise.

The "sideways can" for a lack of a better name is an adapted version of existing cylindrical packages for 32.768kHz crystals, where the leads are bent for SMT mounting instead of being left straight for THT.  It's the same size as the other can packages, and not terribly hard to solder; however, the can itself is mildly fiddly to handle due to the thin leads and relatively small size.

The leadless packages (i.e Leadless Crystal Carrier or DFN) are used for both kHz and MHz crystals, and come in a variety of sizes, all much smaller than the SMT versions of cylinders and HC-49s.  These are generally 4-pin packages, so check footprints carefully as they are not fully standardized.  They can be hand-soldered with care, but are generally used in reflow-only applications, and are not recommended for novices to hand-soldering SMT.  One advantage these packages have is that they also suit 4-pin oscillators, as well as "bare" quartz crystal resonators.