Great question! It is one I had been wanting to write on HN myself for quite some time in the past actually.
I feel I had been in a similar boat. While I did not major in Computer Science like you did, I had, for the past several years, attempted (Unsuccessfully) to become a programmer.
To make a long story short: I realized, much like you, that programming wasn't for me. And yet, like you, I had an interest in technology.
What has ended up working for me is: I gradually moved into the role of system administrator / IT specialist. This role now allows me to be a "Jack of all Trades", be around technology, and help people by solving their problems (The social aspect).
The fact that there is always something new that comes up every day in the life of a system administrator means I don't have much time to get bored. And, when I feel that I might miss coding, there's always something that can be automated by scripting in Powershell (Or your language of choice if you are on Linux, etc).
Have you considered becoming a system administrator? It might be that middle ground that you are seeking.
Edit: One important thing I forgot to add is: The years I spent trying to become a programmer have helped me as a system admin. I can better relate to the development department when they need something set up a certain way, etc. I can understand their language. Therefore, all of that knowledge you have accumulated over the years will only benefit you as you go forward.
To make a long story short: I realized, much like you, that programming wasn't for me. And yet, like you, I had an interest in technology.
What has ended up working for me is: I gradually moved into the role of system administrator / IT specialist. This role now allows me to be a "Jack of all Trades", be around technology, and help people by solving their problems (The social aspect).
The fact that there is always something new that comes up every day in the life of a system administrator means I don't have much time to get bored. And, when I feel that I might miss coding, there's always something that can be automated by scripting in Powershell (Or your language of choice if you are on Linux, etc).
Have you considered becoming a system administrator? It might be that middle ground that you are seeking.
Edit: One important thing I forgot to add is: The years I spent trying to become a programmer have helped me as a system admin. I can better relate to the development department when they need something set up a certain way, etc. I can understand their language. Therefore, all of that knowledge you have accumulated over the years will only benefit you as you go forward.