I prefer to JOIN to the subquery - it should be faster
SELECT DISTINCT f.film_id, f.title
FROM film f
JOIN film_actor fa ON f.film_id = fa.film_id
JOIN
(SELECT actor_id
FROM actor
WHERE last_name LIKE '%depp%'
UNION
SELECT actor_id
FROM film_actor
WHERE film_id =
(SELECT film_id FROM film WHERE title = 'ACE GOLDFINGER')
) actid USING (actor_id)
ORDER BY f.title;