Ok so coming from a gear tech, the whole turn back or don't turn back debate.
A) If you full palm grip and turn any valve, hit the last turn and then budge it more to "make sure it's fully open", then yes you should turn back a little. This is a preventative action for a problem the user causes.
B) If you use your fingertips or loose grip and gently roll the valve until it stops, then you don't need to turn back. Loose grip means when the handwheel stops, your hand slips and rolls over the handwheel. This is also preventative action, but additonally prevents long-term wear/tear damage to the valve.
This is what the inside of a valve looks like. (For those wondering, I killed the threads on purpose, it's a demo/out of service valve)
The more likely issue from doing method A is usually prematurely wearing out annual service parts & non-standard-service parts of the valve. Folks who do the former (A) will overtime round out the inner square-shaped turn post or the handwheel that slots over the turn post. Both those parts are non-standard service parts. As in they aren't intended to be replaced during the life of the valve, assuming people don't abuse it. Practically speaking a lot of divers do, because they budge the valve more after it stops turning. Most do it without knowing, because they palm the handwheel.
Handwheels not reinforced with metal, but full plastic will strip and eventually freespin (after years of abuse). Handwheels reinforced with metal (ie Thermo, XS Scuba, Sherwood) will instead round out the Turn Post after years of that abuse.
In both cases, the handwheel will freespin leading you to not be able to turn your tank on or off per normal operation.
In a rare instance with modern valves, yes you can still seize the valve stuck in the open position; especially if you're that individual that turns it like I described in A, you're using a metal reinforced handwheel, and you're heavy handed.
With the metal reinforced handwheels, you can turn the Seat Plug (made of brass, really the whole valve is soft chromed-brass) so far that you grossly warp the threads. If you haven't figured it out: The handwheel spins the Turn Post, which spins the Seat Plug, which plugs or unplugs your valve closed/open. TA-DAH!
You will slowly warp and bend the brass threads on the seat plug, making them out of tolerance and making the valve stiff to turn. Force it enough and in combination of metal compression/expansion from a cold water dive to warm weather California surface interval, you can cause the seat plug to seize.