Technically and aesthetically, low-poly assets are still in demand today.
Aesthetically because M-MUH RETRO LOOK devs and more commonly slightly lazier 3D who are comfortable with low-poly assets than others (also cheaper depending)
Technical-wise would be due to hardware, mobile games or generally anything running on slower devices require less demanding assets, and certain aspects of games such as having thousands of characters on screen at a time, for example, would best have more optimized and lower-poly assets
That is not to say that they won't be using high-poly assets, but chances are there's going to be a low-poly asset for when it's far enough or out of focus to ensure SILKY SMOOTH performance
But really, just go to any studio that isn't strictly cinematic and low-poly will come to play one way or another