Ive looked through pc mods and most of the mods are awesome! i really want like a patch and addon that adds for example: better water graphics, whiterun foliage overhaul etc. All those ideas on the mods websites can be taken further officially by bethesda. Maybe we could have all these ideas for people who use a console.

This topic has been covered many times before in this forum... the console manufacturers are the ones blocking access to user-created content (ie: mods), not Bethesda. BGS have stated in the past that they would like to provide console users the ability to enjoy mods but their hands are tied because of Sony's and Micosoft's decision.

The best bet is to telephone, e-mail (or go the ancient route and write a letter) to the manufacturer of your preferred console and ask them to reconsider their stance on allowing access to mods. I'm afraid that asking for them in this forum will not bring you closer to your goal.

Letters are very ancient these days.. Phones, Emails, Texting... Future. I sometimes miss the Writing Days.