For best results and most creative freedom just use manually placed planes with rendered “cloud like noise” on them. You can additionally make them more transparent where they intersect other objects and on the edges of the plane and it works wonders.