Low-profile mechanical may be the perfect balance between both types of keyboards.
Several years ago I dove into mechanical keyboards, not the real deep end but not the kiddie pool either. Deep enough to spend maybe a couple grand on it in 3+ years. Mostly standard height(tall) because standard height offers waaaaaaaay more options as far as everything: keyboards, switches and especially custom keycaps. Customizing is fun but I never fully fell in love with the "old-school" height, necessitating need for wrist rests/pads, nor the full-throw depth of the switches. I think I've done enough customization(and spent enough money) on various boards that I can, for most part, leave standard height mechanical keyboards behind, besides the ones I already own, and make the permanent switch to low-profile mechanical or maybe even back to scissor-switch/rubber dome keyboards. Touch ID could be the one feature that could make that happen for me. But I think I'll wait Apple out for another year or three for backlighting and an option for black keycaps on the smaller keyboard, or if Logitech somehow gets permission to add Touch ID to it's keyboards.
The customization options for low-profile seem to be slowly growing, so that could keep me in that world for awhile longer.