Bracket choice gets treated as a spec problem. It is really a room problem: where do people sit, and does anyone ever sit somewhere else.
Fixed
The screen sits flat against the wall, about half an inch off it, and never moves. Cheapest to buy, cheapest to fit, and the best-looking of the three because nothing sticks out.
It works when the sofa faces the wall square-on and the screen lands at the right height. That covers most living rooms.
The catch is access. Once a fixed mount is up, getting a hand behind the panel to change a cable means taking the TV off the wall. If your ports face straight back rather than sideways, plan every cable you will ever need before it goes up.
Tilting
Same flat profile, plus 5 to 15 degrees of downward angle.
You need it when the screen ends up higher than eye level and cannot be lowered — over a mantel, in a bedroom watched from bed, in a room where the only free wall forces the height. The tilt cancels part of the neck angle and cuts glare from ceiling lights, which is a real gain in a room with downlights.
On a wall at correct height, tilt does nothing. Do not pay for it out of caution.
Full-motion
Arms that swing the screen out from the wall, turn it left or right, and usually tilt as well.
Worth it in exactly three situations: an open kitchen where you watch from the counter and from the sofa, a corner installation where the screen has to face into the room, and any wall where you need regular access behind the panel.
What it costs you is depth and honesty. Folded, a full-motion mount holds the screen 2 to 4 inches off the wall instead of half an inch, so the flush look is gone. It also puts real leverage on the fixings — a 65-inch screen at full extension pulls with several times the force it does folded, which is why anchoring into framing stops being optional.
The question that settles it
Does anyone in your house ever watch from a second position?
If no, buy fixed and put it at the right height. If yes, buy full-motion and accept the gap. Tilting is for the case where the height is forced on you and you are stuck with it.
What we see go wrong
People buy full-motion “just in case”, then never move the screen once in three years — they have paid for the gap and the leverage and used neither.
The other one: a heavy panel on a full-motion arm anchored into drywall anchors instead of studs. It holds for a while. Then it creeps, and eventually it takes a piece of the wall with it. On block walls the equivalent mistake is the plastic plugs from the bracket box, which belong in drywall and nowhere else — solid walls need their own hardware.
If you already bought a bracket, keep the box handy when you call. The model number tells us whether it fits your screen and holds the weight before anyone drives out.