To get the Hue Dimmer to work with the other brands of lights, you'll need to either have those lights (and the Dimmer) connected to the Hue bridge and set up the Dimmer there, or you'll need to have the Dimmer on Hubitat and configure the Dimmer there (and have the bulbs on Hubitat somehow, either paired directly or via the Hue bridge). So yes, there are ways to make it work.
You can really use any device to do this, however; the Dimmer is nice because it looks kind of like a "regular" light switch, but it won't mount in a standard wall plate. A Lutron Pico remote can also be used in a similar fashion, but it requires the Lutron Smart Bridge Pro to work wiht Hubitat. However, they mount in standard decorator and are pretty cheap once you have the Bridge. Finally, there are a variety of "buttons" that work with Hubitat that you can also use (the Hank ZigBee 4-button controller is one I considered before I went with Picos--doesn't look like a switch, but it's cheap). You can see a list of natively supported buttons here, though there are more community-developed drivers for things like Xiaomi: Hubitat Elevation supported button controller capabilities matrix
EDIT: The Eria Dimmer Remote is similar, can be paired to Hubitat (and possibly Hue but not configurable via the app, from what I've read), and fits in a standard decorator plate.
