I have always found the LGBTQ+ community generally friendly and welcoming. Your experience may vary depending on where you’re from, and people are people everywhere and there are good and bad in every community. Fear of a bad experience is no reason to stop you from at least trying. If you do t like it, then don’t do it anymore.
Your expectation compared to your efforts will make a big difference in your experience as well. For example if you go out to a club or bar dressed and expect everyone to gush over you and go out of their way to welcome you while you sit in a corner, you’ll probably be disappointed. Go to the same and make an effort to talk to people and be social, and you’ll probably have a good experience.