What is the ruling on staring at the Holy Ka'abah?

All perfecy praise be to Allah, The Lord of The Worlds and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.

Staring/looking at the Holy Ka'abah is an act of worship even if this took place while performing a prayer, since Al-Baihaqee stated that the Prophet (PBUH) said: " Staring at the Holy Ka'abah is an act of devotion." [Sho'aab Al-Imaan]. And Allah Knows Best.

Is everyone obligated to follow the fatwas of his country, and if we adopt the fatwas of scholars of other countries, is it considered a sin?

All perfect praise be to Allah, The Lord of The Wolrds and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.

It is permissible for the person who isn't specialized in Sharia sciences to apply the opinions of renowned scholars whom he trusts ,whether they be from his own country or not ,but if the scholars have different opnions regarding a certain issue/matter, then he must consult someone who is more knowledgeable than himself .It is preferable that you (the questioner) specify the case of your interest ,so that we could give you a more specific answer since some scholars deliver fatwas based on illogical/atypical opinions which should not be applied no matter what .And Allah The Exalted Knows Best.

Should one obey his mother even if she was wrong?

Obeying one`s mother is an obligation in matters that are beneficial to her and so long as she didn't drive her children to commit an act of sin.

One day, I swore that my wife will be unlawful to me to quit smoking hookah?