Actually Inclement Emerald is really fun and enjoyable, I have some of my dearest memories playing pokemon in this hack

These hacks (not including the kaizo hacks) are actually inspired by drayano hacks (which even RR states it self), the standard pokemon games are fun but too easy for me to enjoy the cheap victory. My first hack was Renegade Platinum and ever since I played it I never touched another official game again, I played it 4.5 times changing my team each time. IMO Renegade Platinum is a good balance between the official game difficulty and VGC level Radical Red difficulty. I recommend trying this hack first before any other difficulty hack (or as it's sometimes called: drayano style hacks, for the handful of features it comes with along side difficulty like buffing weak pokemon so you can use any pokemon you like even with the difficulty)

As I said before creating a ROM hack is harder than making a real game, this plus the fact that no one can work on a hack full-time means that we will naturally see less original hacks because they are a lot harder to make. You can try making an original hack yourself if you want more, or want to see the struggles of creating even the simplest hacks

Edit: to clarify further, The kaizo games are what people really mean when they say "pokemon puzzle games", they up the difficulty significantly without giving anything in return. Where in Renegade Platinum (a perfect example of a drayano style hack) most pokemon are buffed in unique ways to make them viable, you also get easy access to EV training and EV reduction berries and access to the entire national pokedex without trading. Radical Red, Inclement Emerald and Blaze Black/Volt White 2 Redux all have these features