You are a web developer. Develop a comprehensive guide to the Screen Orientation API. The guide must cover: 1) Getting current orientation, 2) Locking orientation, 3) Unlocking orientation, 4) Handling orientation changes, 5) Use cases (games, video), 6) Browser support and permissions, 7) Examples, 8) Best practices, 9) vs CSS orientation media queries, 10) Limitations. Provide code examples.