I would agree I also have problems with G9 LED, but rest the main advantage is they never seem to fail, had one which replaced a fluorescent tube fail and some really cheap toys from pound world 0.58W G5.3 MR16, other than those no failures, that is over now 4 years, never used halogen, still have a stock of pearl tungsten bulbs, but only use is to keep beer warm when brewing, and at moment don't need that much heat so using a 11 watt CFL.
As
@AndyPRK says most my lamps from B&M or Home Bargains some were from Lidi, the odd one (fluorescent tube replacement) from
Screwfix failed. I will admit they don't on balance save energy, however oil is cheaper than electric, so they do save money, but the thermostat had to be changed for a programmable type as want the temperature higher in the evening and the radiant heat from tungsten bulbs heats the body but not the air, so does not work the wall thermostat, so means near instant night time comfort temperature rise as you enter a room and switch on lights, which is not affected by air changes, ideal would be LED in summer and tungsten in winter, but since lights used less in the summer tungsten lights are really energy saving, but don't save money as gas and oil cheaper than electric.
I have never liked quartz bulbs, one is the danger all quartz bulbs have to have a glass to stop hot bits dropping on carpet, and also glass to stop the harmful rays from them, also you want a defused light so unless the glass is pearl then it needs a globe over the bulb to disperse the light, quartz lights 25 foot or higher are OK but not really for in door use, seems some one conned the government into allowing them.
I found the so called energy saving bulbs, were not as bright in the same fitting as tungsten, so to swap had to change light fittings, also they are directional, so the single 100 watt pearl tungsten bulb in living room has been changed for a chandelier with 8 x 6W LED bulbs with base at bottom shining up onto a white ceiling to give a good spread of light, so 100 watt replaced with 48 watt, that is not what the charts say is required as equivalent, but the single 100 watt bulb was not really good enough anyway, but I don't have any 150 watt bulbs.
Some rooms have been straight swap, previous owners had quartz bulbs everywhere, still a few kicking around, and I have such a stock of tungsten bulbs and the rooms where not changed are not used much, so likely now wait until tungsten stock used up.
As to your post, transformers do tend to buzz, but whole idea of the transformer was to allow the bulb to use a thicker filament so they last longer, and in the main transformers were replaced with electronic units which also regulated the average voltage as quartz bulbs must run as a set temperature to have a reasonable life, so should not be dimmed, and the regulated power supply (electronic transformer) often has an output in the kHz range and a minimum output, so in the main not suitable for LED one because of the frequency which can cause radio wave transmission and also LED's don't use enough power, and also the switch mode power supply can interfere with the pulse width modulated driver built into the LED bulb, so if extra low voltage LED lamps are used, either a toroidal transformer or a DC supply needs to be used. Many LED lamps are marked 50 Hz.
I think anyone claiming LED or CFL are energy saving should be reported to trades descriptions as they are in the main only energy saving when used outside or in the summer, but they are money saving and maintenance saving, I remember when we had all tungsten once a fortnight I needed to change a bulb some where, I bought packets of 10 mixed bulbs 40, 60, and 100 watt and had a cupboard with spare bulbs and fuse wire, as when they failed often there was ionisation (the big flash) which could rupture the fuse, even worse when I moved to a MCB, quite common for a failing bulb to trip the braker.
Once one has had LED's for a few years you forget how bad it was, I fitted loads of dimmer switches back in the old days of tungsten as the bulbs lasted longer (except for quartz) they have all now been removed, and look back on it as a 70's fad.