My suggestion would be to put a dimming module in the ceiling for each pair of (dumb) lights. Then use whatever smart switch you want to trigger an automation which powers on/off your lights. This would give you power control at the switch and dimming via HA app.
If you want dimming control directly from the switch, your options are limited to 2 unfortunately, and both have their drawbacks:
- Philips Hue Tap Dial - covers all your requirements but is battery powered.
- This project - essentially a custom Tap Dial project with mains input, but is still in prototype stage.