"VIP room" is a pretty vague term that varies based on the specific club. In some clubs, it's just a separately roped-off, elevated, or partially-glassed area, while in some clubs it is a completely separate room. It usually has plush seating and possibly bottle (liquor or champagne) service at your table/area included or for an extra charge. It may also have its own bar, which can definitely save some time and hassle in extremely crowded clubs. You definitely can't find what you are looking for on the internet as different clubs vary widely in what they consider to be a VIP room. What you see on the internet is an idealized version most likely with paid "stars" and a production company paying off the ownership to film in the VIP area.
In the majority of open area VIP rooms, you're likely to find a group of well dressed people drinking and having a good time, with more women than men because in most clubs it's much easier to get into the VIP area (especially free) as a woman than a man. Depending on how open-minded the VIP security happens to be and how private the area, you may also find people doing CC or smoking MJ, but in most clubs that's not something that you would necessarily know ahead of time, just something you may run across. There's a pretty good chance that some people might also be rollin, but you wouldn't notice they were doing that unless they're being blatantly obvious taking it right in front of you.
Getting a permanent pass to a VIP room is fairly unlikely, if only because of the high turnover in the club bouncer profession. If you happen to become good friends with a club owner or general manager, then you may be able to get in free with more regularity to the VIP area, but only as long as that person remains the club owner or manager (also decent turnover for most average clubs). The times that I have been into VIP rooms completely free have usually been with a small group that included women that knew the bouncers or club owners. As a guy you're pretty much going to have to pay to get into the VIP area most of the time. You may be able to grease palms to get in a little cheaper than the going rate, but I wouldn't count on it regularly unless you get in really good with a bouncer that stays there for a long time.
You probably wouldn't want to walk up solo into a VIP area, it's more of a couple or group type thing. Walking into a VIP area by yourself would probably catch an eye from most of the people in there and not necessarily in a good way unless you happen to be tossing baggies onto the table.

Ideally you'd want to roll up into a VIP area with a small group of singles and/or couples. A lot of clubs will max out your VIP entrance at 4-8 unless paying individually.