.410 is a round with very limited utility. It's really a 68 Gauge. It was once called "36 Gauge" but that was a lot like the .38 Special -- driven not by real numbers (.38 really measures .357) but marketing (.35 Special sounded puny). That is to say, calling it a 36 Gauge was a flat-out lie.
It works great when you really want a .410, so it has its strong adherents. And some people like to shoot it for the challenge. There was a friendly competition between some guys in my trap league a while back. One of them now has a vest with the big numbers 410 on it, over a 25 patch. He said it cost him about $1400 in ammo to get it.
He routinely scores 25 with everything from a first-year 870 to some oddball Valmet O/U that looks like a Model 32.
So it can be established that a .410 cannot replace a 12 Gauge or 20 Gauge for trap or bird hunting. That's not to say you can't hit a bird with .410, just that it won't work anywhere near as well as 12 or 20.
So what about 28?
That depends. If you get a 28 built on a special frame or receiver, then it has its real advantages. You won't find a lighter, quicker shotgun that still packs the punch necessary for hunting and some clay work. But if it's the same size and weight as a 20, with slightly smaller bores, then it's just a 20 Gauge with more expensive ammo, IMHO.
The point of the 28 Gauge is to build the lightest gun with the lightest round, that still functions as desired for upland hunting. Note that a light, quick shotgun is not always what you want! Some serious trap shooters put lead weights in their already big and heavy guns. My new trap gun is a 34" barrelled beast with lead in the buttstock, and it feels great. Wouldn't want to hunt doves with it. Wouldn't want to shoot trap or passing ducks with a 28, either.
Most of us can get what we want from a light, well-made 20 gauge double like a Beretta O/U or the CZ Huglu SxS. The ammo is cheaper, and you can choose heavy or light loads that suit most purposes perfectly.
Unless you have plenty of money, a good sized gun collection, and plans for hunting trips to Argentina, I'd suggest that a 28 is not the best use of your cash. And that a .410 is a waste, unless you have a real need for one, and if you did, you'd already know it.