Not quite RIP Halogen in the EU..
Fridge and oven lamps, R7s, G9 halogen lamps and most 12v G4 are untouched by the bans, as they cannot be adequately replaced by other technologies.
R7s are that rod shaped halogen bulb often used in floor standing torchieres with the light shining up onto the ceiling. G9 capsules are the ones you probably want for their versatility. There is a German company (forget which) that lets you plug G9 caps into a bulb fixture/bulb casing and then you can pop it into your standard fixture. There are a bunch of desk/reading lamps though, that will take a G9 directly.
As for fluorescents, it's not hard to have an electronic ballast in fixture for standard fluorescents. I've converted a few T12 tubes which were on magnetic ballast, to electronic. T8 tubes are better, but I wasn't going to buy new fixtures or tubes when the basement is full of T12.
Not sure how hard it will be to find fluorescent tubes moving forward as new installs are using LED replacements in a tube format, but! if the power source for the LED tube is direct current, then there is no flicker..
And along those lines.. here is a German company that specializes in making lighting solutions for chickens which are more sensitive to flicker than humans.. (seriously).. why not try one of those bulbs like the Xena which they named as being chicken-safe.. it'll screw right into your standard fixture.
https://www.ilox.eu/en/technic-info/163-photometric-flicker