You're using your words wrong.

"Tight geometry" generally refers to seat tube and head tube angles greater than 73 degrees as well as shorter front end and chain stay measurements.

"Chode stems" generally refer to stems too short for effective rider placement. Generally used by riders with a less than ideal amount of knowledge about how a bike is supposed to fit. This creates issues with the handling and rider comfort during different positions. You want a frame with a proper length top-tube so you can use an appropriate length stem (80/90-120mm)

I don't think you know what you're doing with respect to fitting.