So I just did the first half of my first sour last night. Doing a cranberry kettle sour. I felt the same way, thought I was in over my head when my wife asked me to do it. The first one is the hurdle, sounds complex but not terrible.
1. Pick a grain bill. I did a simple 60% white wheat / 40% Pilsen grain bill, similar to what you would see in a Gose style.
2. Pick the "bugs". I went with Omega OYL 605 Lactobacillus.
3. Pick the yeast to finish fermentation. I picked US-05.
4. Start your brew day as usual with your 60 min mash, sparge, and lauter.
5. Once your complete with that and your wort is in your boil kettle, perform a quick boil to kill off any unwanted bugs.
6. Chill the wort to desired bug temp. For the OYL 605, it was 95*F.
7. Add lactic acid to pre-acidify wort to 4.0 - 4.4 pH.
8. Pitch the bugs (the lacto or whatever you choose).
9. Let it sit until desired sourness is achieved.
10. Continue with your 60 min boil once sourness is achieved. Add hops to taste.
Sounds like a lot, but not bad. I will agree with cactus and say that if you're undecided at this point, put it off for another day until you have a plan. Going into a brew day without a plan is not a good idea in my opinion. I can't say how this one turned out yet but the process is fairly user friendly.