We understand that you are going through a difficult time missing your spouse and claiming the promises of Jesus in John 14:12-16. Let's pray and consider this situation together.
Firstly, let's look at the verse you mentioned.
Truly, truly, I say to you, he who believes in me, the works that I do, he will do also; and greater works than these will he do, because I am going to my Father. Whatever you will ask in my name, that will I do, that the Father may be glorified in the Son. If you will ask anything in my name, I will do it. If you love me, keep my commandments. I will pray to the Father, and he will give you another Counselor, that he may be with you forever: the Spirit of truth, whom the world can't receive; for it doesn't see him and doesn't know him. You know him, for he lives with you, and will be in you. (John 14:12-16 WEB)
It's wonderful that you are coming to Jesus with your needs. He indeed promises that whatever we ask in His name, He will do it. However, we must also remember that God's will and His glory should be the primary focus of our prayers. This means that our requests should align with God's principles and His desires for our lives. Also, let's change a phrase in the request. It is a very bad idea to think, say, or pray for things to be perfect. If things were perfect, we would not need God. God will not answer a request for perfection.
In your prayer, you're asking for your spouse to return and for your marriage to be perfect. While it's commendable that you are seeking reconciliation, it's essential to ensure that your desires align with God's will. Praying for a godly spouse and a marriage that honors God is excellent. However, we must also be prepared to accept God's will, whatever that may be.
Let's also consider what the Bible says about marriage:
Wives, be subject to your own husbands, as to the Lord. For the husband is the head of the wife, as Christ also is the head of the assembly, being himself the savior of the body. But as the assembly is subject to Christ, so let the wives also be to their own husbands in everything. Husbands, love your wives, even as Christ also loved the assembly, and gave himself up for it; that he might sanctify it, having cleansed it by the washing of water with the word, that he might present the assembly to himself gloriously, not having spot or wrinkle or any such thing; but that it should be holy and without blemish. Even so ought husbands also to love their own wives as their own bodies. He who loves his own wife loves himself. (Ephesians 5:22-28 WEB)
This passage reminds us of the roles and responsibilities of husbands and wives in a marriage. It's crucial to strive for a marriage that reflects the relationship between Christ and the church.
Let's pray together:
Dear Heavenly Father,
We come before You in the name of Jesus, lifting up our brother/sister in need. Lord, we ask for Your will to be done in his/her life and marriage. We pray for his/her spouse, that You would work in their heart and draw them back to this marriage if it is Your will. We ask that You would help them both to be faithful and committed to each other, reflecting the love of Christ and the church.
However, Lord, we also submit to Your will. If it is not Your desire for this marriage to be reconciled, we pray for Your comfort and guidance for our brother/sister. Help them to trust in You and to seek Your face during this challenging time.
In the name of Jesus, the One who paid the penalty for sin on the cross, resurrected from the dead on the third day and the only name by which we can be saved, we pray. Amen.
Be encouraged, and continue to seek God's will in all things. Remember that God is faithful and that He desires the best for you. Trust in Him, and He will direct your paths.
Also, let's remember that,
For I know the thoughts that I think toward you, says Yahweh, thoughts of peace, and not of evil, to give you hope and a future. You shall call on me, and you shall go and pray to me, and I will listen to you. You shall seek me, and find me, when you search for me with all your heart. (Jeremiah 29:11-13 WEB)
We should trust in God and seek Him with all our heart.